READ TXT FILE TO EXCEL

[PUwaterpolo9]

I have a text file with 5 columns and 29 rows. I want to read this file and put it into an excel spreadsheet. How oh how do I do this??

 

[xlbo]

File>Open>Browse for text file > go through import wizard>done

record it if you need to automate

Otherwise you can use ADO but that involves using SQL

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[SkipVought]

Another option is Data > Import External Data > Import File. If you are doing this on a regular basis, this query table can merely be refreshed to import a fresh set of data.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[DougAJ4]

This blog post:

http://newtonexcelbach.wordpress.com/2008/05/19/importing-text-files-with-vba/

has a VBA subroutine for importing text files into a spreadsheet that may be of help.