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.
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.