How to make access import large tables without skipping columns?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to import a large table ( close to 200 columns ) from an old
database using ODBC, but it seems like access has a limit on the number of
columns per a table. How do I make access import large tables without
skipping columns?
 
cbshoush said:
I am trying to import a large table ( close to 200 columns ) from an
old database using ODBC, but it seems like access has a limit on the
number of columns per a table. How do I make access import large
tables without skipping columns?
Click to expand...

Access has a limit of 254 (255?) fields per table. How about importing
groups of 100 or so and then normalizing them then combining the results?
 
You must log in or register to reply here.

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
How to export table from outlook into ms access table? 0
Hitting the limits with large table in Excel containing 1 millionrecords. What is the best option fo 2
TransferSpreadsheet skips rows 1
Can Anyone Suggest a Way to Remove a Password from a PST File Without Outlook? 1
Column Headers in Access Tables 2
Import Excel data - need to map columns. 2
Linking Access to selected fields in a large external table 1

Back
Top