Importing a Text File

[kshadden]

I have a text file that is sent from a mobile device through a modem, via cell phone, then through a host modem into my computer. The text file comes over as

Record Number
Van Number
Date Time
Problem Type
License Number
Longitude
Latitude

When I try to import it creates 7 record in the Record Number column. Is there a way to parse this so the the text file reads

Record Number, Van Number, Date Time, Problem Type, License Number, Longitude, Latitude

All on one line.

Thanks for your help.

 

[pbrodsky]

How large a file? How often?

The obvious answer is to use VBA to add the data to the table. If the quantity is small and infrequent enough, it might be practical to load the file into Word and use Convert Text to Table to create a table.

 

[kshadden]

Being kind of new to this how would i wus VBA to do this?

 

[psemianonymous]

The short answer is that there's no simple way to get your data for you. The answer he gave you above ("use VBA") means to write a program to manually figure out the data structure.

You can get out of all this program by buying something like Monarch (~$800 or so) or you can do the programming yourself. There's no free option unfortunately.