Importing delimited file into MS Access

A

Andre T.

I need to import a tab delimited file into MS Access. It has over 100
columns of data but MS Access recognizes only the first 14 columns. It
seems MS Access only looks at the first few rows but he 100 columns row
appears around 300th row.

I don't want to rename the rows because that may get users confused.

I can't import it beyond the 14th columns.

What are my alternatives?

Thanks for your advice
Andre T.
 
A

Andre T.

I can, but it would be a difficult task for the users to do it as a daily
routine work.

Thanks for your advices though. I really want to import directly into MS
Access without manipulating it.

Andre T.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Newbie question concerning Tab delimited files 1
Importing delimited file into Access 4
Count columns in delimited file 3
Access 2003 can't import delimited files 1
Import using schema.ini file 1
Trouble Importing text file into Access 2007 1
importing a delimited file with more than 255 columns 9
Import tab delimited multiple files using VBA 4

Top