Access export to dbf errors

How can I easily export long field names from an Access database into a dbf format?
claryalAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Zlatko KuzmanovskiprogrammerCommented:
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.
Zlatko KuzmanovskiprogrammerCommented:
(small fix) .DBF supports 10-char field names.
ClarkFilterCommented:
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?
Price Your IT Services for Profit

Managed service contracts are great - when they're making you money. Yes, you’re getting paid monthly, but is it actually profitable? Learn to calculate your hourly overhead burden so you can master your IT services pricing strategy.

claryalAuthor Commented:
have numerous mdbs with the same fields - would the query approach be transportable?
ClarkFilterCommented:
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?
ClarkFilterCommented:
For the transportable question, if your table names and fields are the same, you should be able to copy the query into other databases.  But that is not the original question for scoring points...  :)
pcelbaCommented:
You may export long field names into Visual FoxPro DBF which is a part of database container (DBC). You may use VFP ODBC driver to do it.

Another option is to connect Access database via ODBC driver from Visual FoxPro and import tables via SQL pass-through commands.

The question, of course, is how would you like to process these DBF files?
claryalAuthor Commented:
Thanks to all for your comments. I'm pulling data for statistical analysis but don't have a direct link to mdbs.  i frequently do this via a dbf file which is quite easy.  I found a slightly more complex approach using a text file and then a script to load this into the stats tool.  

Appreciate everyone's thoughts and ideas.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.