Export Access to dBase

[junksignup]

I've been recently assigned the task of exporting an Access Query table to a dBase III database. I know I can export it through Access to a .dbf file using Save As/Export function but I can not get the results I will need for our client.

The problem is this: Some of our table fields are different than the clients table fields and the field sizes are also different too.

Our data is the correct data for their database.

So my question is this:
Example -
I have a query table with a field name "Sample_ID" and I want to export it out to our client in dBase III compatible format (.dbf) with a table field name of "Sample_Name" ; field size "12" Characters.

The majority of field names match exactly between the databases, probably less than 10% do not match.
The data types are correct in all field names but the field sizes vary.

Exporting issues:
Many different "Field Names" with different "Field Sizes"
Compatibility

How do I export the query data from Access to dBase III properly addressing the issues previously explained?

 

[BillPower]

This should be quite easy to do. Create a new table in Access, naming and formatting all the fields in it the same as the dBase III database table. Create an append query to append the existing table to the new dbIII table. Save As/Export that. Also create a delete query on the new dbIII table which you will need to run each time before the append query.

Hope this makes sense.

Bill