import text file with more than 256 columns

  • Thread starter Thread starter ken
  • Start date Start date
Access cannot process > 256 fields, so you will need to pre-process the file
to break it down.

If you are using Office 2007, you may be able to do that pre-processing in
Excel.
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Test-To-Columns > 256 4
How can I import a csv file with over 256 columns into Excel? 2
how can I import a csv file to Excel that has over 256 columns? 2
Importing Text Files Into Access 1
Problem with date when importing 1
Import using schema.ini file 6
Want more 256 column in 2007 3

Back
Top