Export to .dbf

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BackinApps - 14 Jul 2005 15:35 GMT

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?

Signature

G. Jay Myatt, Jr.
IT Specialist
Cook County Clerks Office
Chicago, ILL

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

Reply to this Message

Klatuu - 14 Jul 2005 16:28 GMT

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.

> 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
[quoted text clipped - 3 lines]
> result table and manually invoking the export function with a output format
> of dbase 3?

Reply to this Message

BackinApps - 14 Jul 2005 17:29 GMT

Thanks that pointed me in the right direction and solved my problem....

Signature

G. Jay Myatt, Jr.
IT Specialist
Cook County Clerks Office
Chicago, ILL

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

> 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
[quoted text clipped - 8 lines]
> > result table and manually invoking the export function with a output format
> > of dbase 3?

Reply to this Message