Importing Data -- Field Name limitation

J

jkrafft

I am importing 111 field names from a raw data file. The
file specs will not allow me to save over 30 field names. Why?
 
C

Cheryl Fischer

Do you mean that you are attempting to import 111 fields (not field names)?

Access (2002 anyway) has a limit of 255 fields per record *and* a limitation
that a record may not contain more than 2000 total characters, excluding
memo and OLE object fields. So, is the length of any individual line in
your raw data file more than 2000 characters?
 
Top