Export to .dbf

[Guest]

I have a query that I need to export the results to a dbase file format. In
using the Macro function .dbf is not one of the choices and there are two
many records to export to a Excel file.

Does anyone know how I can export to .dbf format other than creating a new
result table and manually invoking the export function with a output format
of dbase 3?
--
G. Jay Myatt, Jr.
IT Specialist
Cook County Clerks Office
Chicago, ILL

312-603-1123 Phone
312-603-0982 Fax

 

[Guest]

You can use the TransferDatabase method. The database type will be "Dbase
III" or "Dbase IV", most likely. It will depend on the version of Dbse that
created and uses the database. See TransferDatabase in Access Help for more
detail.

 

[Guest]

Thanks that pointed me in the right direction and solved my problem....
--
G. Jay Myatt, Jr.
IT Specialist
Cook County Clerks Office
Chicago, ILL

312-603-1123 Phone
312-603-0982 Fax