What is the limit on fields I can import into a table?

[GeorgeR]

I'm trying to import fields via an odbc. Is there a limit as to the number
of fields Access will IMPORT. The table I'm trying to import from has
aproximately 300 fields. Thanks for any thoughts

 

[Pete D.]

255 is the limit but if you expect to do anything with it afterwards I would
keep them under 200. Do it in parts and add keys to the file first if
needed to piece them back together.

 

[Jeff Boyce]

George

The source data has approximately 300 fields. Odds are pretty good that
this is NOT a well-normalized design.

What table design do you have in Access? Have you normalized it?

You could import a limited set (less than 255) of the fields as "raw data",
then use queries in Access to parse the raw import data into the final
(normalized) data structure.

Good luck

Regards

Jeff Boyce
Microsoft Office/Access MVP