Importing delimited file into MS Access

  • Thread starter Thread starter Andre T.
  • Start date Start date
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.
 
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.
 
Back
Top