Exporting a table through a command button on a form 1

[dsmart16]

Help,

Hi there, I'd like to be able to export a table by clicking on a button that is on one of my forms.

Here's what I have:
tblSurveillance
frmReports
cmdExportTable
Exported Tables (a folder on my hard drive)
SurveillanceExported.mdb (a blank database in the Exported tables folder

So I am looking at the frmReports form, and when I click on cmdExportTable I'd like to have it export the tblSurveillance table the the SurveillanceExported.mdb database in the Exported Tables folder on my hard drive.

If you need any more information please let me know, thanks for all your help.

Dave

 

[Remou]

Hi
Have you looked at the TransferDatabase Method? You could add (for example):

DoCmd.TransferDatabase acExport, "Microsoft Access", "C:\Exported Tables\SurveillanceExported.mdb", acTable, "tblSurveillance", "tblSurveillance", False

to the ONClick event of cmdExportTable.