In Access 2000 I am doing the following:
1) Running 3 separate select queries that pull different records from one table.
2) Running a union query to combine the results of #1
3) Running a make table query to transform #2 into a real table, not just a query.
The text fields in the resulting...
Thanks to WildHare for suggesting I check my record length. A query I was running, that combined fields from two tables, was setting all my text fields to 255 characters in length. Truncating them to their appropriate sizes allowed the table to export correctly.
Thanks again,
TSR
I'm trying to export an Access 2000 table (30 fields by 30,000 records) to dBase IV format. I receive the error message "Field will not fit in record".
I have checked to make sure that no field names begin with numbers, and that no field names will be identical if the dBase format...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.