claryal
asked on
Access export to dbf errors
How can I easily export long field names from an Access database into a dbf format?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I am not sure if dbf is really limited to 8, since we have plenty of dbf files that we work with with more characters than that. Just how long are your field names?
ASKER
have numerous mdbs with the same fields - would the query approach be transportable?
Even with changing the output to dBase V, it is still limited to 10 characters for the field names, truncating anything longer.
It looks like you are stuck with the 10 character limit if you stick with dBase.
Why do you need dbf files? Are you able to use another format, such as Excel? If you have Excel 2003 or earlier, you will be limited to a little over 65k records, but have a much higher limit with Excel 2007. Text file output will also allow longer field names.
If an external application is using your output, is it possible for it to directly use Access tables?
It looks like you are stuck with the 10 character limit if you stick with dBase.
Why do you need dbf files? Are you able to use another format, such as Excel? If you have Excel 2003 or earlier, you will be limited to a little over 65k records, but have a much higher limit with Excel 2007. Text file output will also allow longer field names.
If an external application is using your output, is it possible for it to directly use Access tables?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
DBF supports 8-char field names. So you must make a query first, rename long fields, and then export the query to a dbf.
Please ask if more help is needed.
Zlatko.