"The field is too small to accept" error in Access 2003 using Foxp

R

rkennebeck

I am trying to link a foxpro table in Microsoft Access 2003 using ODBC. The
package I'm linking to is in VFP 9 (I believe).

When I do the link, and then try to open the table, it says:

"The field is too small to accept the amount of data you attempted to add...."

When I view the structure in Access, I notice that there are several binary
fields. When I query the table specifically leaving out the binary fields, I
don't get the error. These fields would normally be character fields since
they contain addresses, phone numbers and zip codes, but for some reason they
used a binary field instead of character fields.

These fields do not appear to be memo fields since they have a length on
them such as 12, 15, etc.

I can open this table up in Excel and I see the data in those fields and it
appears to be the hex version of the character data.

How do I read this information in Microsoft Access?

Thanks in advance for your help.
 

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

Top