txt file to csv file

[Guest]

Researching into a way to import a .txt file which can contain over 66,000
lines/row into a program and having an export file type of .csv. I know that
Excel is limited to 65,535 rows and 256 columns. Right now I am concerned
about the number of rows, and later will need to visit the column max limit.

Looking into acces to acceive this, but not experienced in Access. Can this
be accomplished?

Or, is there a simple program that will do this?

Please let me know.

Thanks,

Tim

 

[Ken Snell \(MVP\)]

ACCESS has a built-in method to do this. Check out TransferText in the Help
file.

 

[Guest]

Thanks Ken,

Figured our how to import the txt file, but need to save as a .csv file type
in a single sheet that contains more than 65,535 rows. Now that is the
challenge. Ant suggestions?

Tim

 

[John Nurick]

Access doesn't have a set limit on the number of rows it can export to a
CSV file, though other limits can kick in when you're dealing with
millions of rows. However, Excel won't be able to handle a CSV file
containing more than its own limit of 65536 rows.

Also, there's no way of fitting more than 255 columns in an Access table
(and in a well designed database there's _never_ any need to. The same
limit applies to columns in an Access query.