Importing Data From multiple Text files

Excel Help for Importing Data From Multiple Text Files in Automating Data Analysis Tasks

Importing Data From Multiple Text Files

Rate this: (3/5 from 1 vote)

	To anyone that can Help: I have many text files formated like the below sample that I would like to import into excel. Tue 01/06/2009 11:41:05.33 System information for \\61901-jleonard: Uptime:                    0 days 4 hours 13 minutes 45 seconds Kernel version:            Microsoft Windows XP, Multiprocessor Free Product type:              Professional Product version:           5.1 Service pack:              3 Kernel build number:       2600 Registered organization:   ADM Alliance Nutrition Registered owner:          ADM Alliance Nutrition User Install date:              1/7/2008, 4:25:23 PM Activation status:         Activated IE version:                7.0000 System root:               C:\WINDOWS Processors:                2 Processor speed:           1.7 GHz Processor type:            Genuine Intel(R) CPU            2160  @ Physical memory:           1016 MB Video driver:              Intel(R)  Q965/Q963 Express Chipset Family Volume Type       Format     Label                      Size       Free   Free     C: Fixed      NTFS       WinXP                   24.4 GB    16.3 GB    67%     D: Fixed      NTFS       Data                    49.9 GB    40.7 GB    82%     E: Fixed      FAT        MS-DOS_6               203.7 MB   182.8 MB    90%     F: CD-ROM                                                               0% Applications: ADM PC Scan 3.0.0.0 Adobe Flash Player 10 ActiveX 10.0.12.36 Adobe Reader 8.1.2 8.1.2 Agere Systems PCI-SV92PP Soft Modem Broadcom Management Programs 9.03.02 Broadcom NetXtreme Ethernet Controller 9.02.07 I would like to import them with rows for uptime | Kernel Version | Product Type | etc.... Any help is greatly appreciated. Jason
	Posted by jgerding on 31 Jan 2009

Replies - Displaying 1 to 1 of 1

Order Replies By: Most Recent | Chronological | Highest Rated

	Use the FileSystemObject Rate this: (3/5 from 1 vote) You can read in text files within Excel by using the FileSystemObject in VBA code: VBA Code: Sub Read_text_File() Dim oFSO As New FileSystemObject Dim oFS Set oFS = oFSO.OpenTextFile(”c:\textfile.TXT”) Do Until oFS.AtEndOfStream sText = oFS.ReadLine 'Do here what you need to do with the line of information Loop End Sub
	Excel Business Forums Administrator
	Posted by Excel Helper on 02 Feb 2009

Displaying page 1 of 1