Exporting a Query as a dBase file

[fif_rumac]

Hello,

I was hoping that someone could help me...

I am aware that you can export a query as a dBase file by going to the file menu and down to export... however I am hoping that there is a way to automate this process using vba code.

The code would need to select the query to export (query called "updates"), select the export file type (dBase 5), and then execute the export command...

Thanks

fif_rumac

[OBP]

Try this -
Domcd.TransferDatabase acExport, "dBase5", "The dbase database name", acQuery, "updates", "dbase name of query or table data is going to"
the dbase database name must be the full path and must already exist

[fif_rumac]

Thanks very much... I'll give it a try