Importing Data -- Field Name limitation

  • Thread starter Thread starter jkrafft
  • Start date Start date
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?
 
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?
 
Back
Top