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?
 

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

Grouping Names in Mail Merge 0
Mail Merge Directory Conditional Page Break 0
Extract name, address and ph# 8
VBA - exporting serial letters to single documents 0
Cannot import CSV file into ACCESS 1
New Specification File 4
Copy previous record into form field 0
Difficulty with compatibility mode and Track Changes 2

Top