Table Error Message

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

Guest

I am importing data from a survey into multiple tables in access. One table is large, but not to be split. I need to amend the field type from Number to Text on some fields. Error message comes up on save. "Too many fields defined" will not save changes. Can anybody help with this as I need to get this data imported.
 
You can only have 255 fields per table in an Access database.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdeisgns.com/Security.htm


Di said:
I am importing data from a survey into multiple tables in access. One
Click to expand...
table is large, but not to be split. I need to amend the field type from
Number to Text on some fields. Error message comes up on save. "Too many
fields defined" will not save changes. Can anybody help with this as I
need to get this data imported.
 
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

Record is too large. (Error 3047) 4
How to subtract a number from a Mergefield? 0
Using Collect Data with Related Tables 3
Data Type Issue 5
Type Conversion Error While Importing (Time Field) 8
Rounding Numbers 2
Import table error 6
An error occurred trying to import file 'c:\temp\import.txt'. The file was not imported. 0

Back
Top