Error message - "Record is too large."

[Randal]

I am trying to import a VFP table and receive the error message "Record is
too large." I can link to the table, but when I try to use a make table
query I still get the message. I have tried to exclude an "memo" fields,
but still get the error. Any help is appreciated.

 

[Joe Fallon]

There may a difference in the number of fields and their size between what
Access allows and Foxpro allows.

Can you run a Make Table query off *some* of the fields in the table?
Just not *all* of the fields?

Are there over 255 fields?

 

[Randal]

249 fields. I suspect that one of the fields has more data than Access
allows, and would be happy to remove it from the query if I knew how to find
it?

 

[Joe Fallon]

It may not be any *one* field that is too large.
The combination exceeds Access ability to store the record.
249 fields in a single table is rather high for a relational database.

Check Help to see what Access can store in a single record.
(Number of fields is 255, but what about # of bytes?)

Use 2 make table queries and send 1/2 the fields to each table
(and the PK to both.)
Then in Access you should be able to re-link on the PK and query both
tables.

 

[Randal]

it works. Thanks.

It may not be any *one* field that is too large.
The combination exceeds Access ability to store the record.
249 fields in a single table is rather high for a relational database.

Check Help to see what Access can store in a single record.
(Number of fields is 255, but what about # of bytes?)

Use 2 make table queries and send 1/2 the fields to each table
(and the PK to both.)
Then in Access you should be able to re-link on the PK and query both
tables.