Home > Forum Home > Automating Data Analysis Tasks > Importing Data From multiple Text files Share

Importing Data From multiple Text files

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


Forum TopicPost Reply Login

Importing Data From Multiple Text Files

Rate this:
(3/5 from 1 vote)
ConfusedTo 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 on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Happy
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 on
 Displaying page 1 of 1 

Excel templates and solutions matched for Importing Data From multiple Text files:

Solutions: Export MapPoint Waypoints Survey Data Analysis

© Business Spreadsheets   Legal   Follow us: