Link to home
Start Free TrialLog in
Avatar of claryal
claryal

asked on

Access export to dbf errors

How can I easily export long field names from an Access database into a dbf format?
Avatar of Zlatko Kuzmanovski
Zlatko Kuzmanovski
Flag of North Macedonia image

HI,
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.
SOLUTION
Avatar of Zlatko Kuzmanovski
Zlatko Kuzmanovski
Flag of North Macedonia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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?
Avatar of claryal
claryal

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?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Pavel Celba
Pavel Celba
Flag of Czechia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial