Exporting tables via VBA

[maverickmonster]

I have some tables that once made by a make table query i want to export to a user defined area is there anyway to bring up a popup box to let them save the table where they want ?

 

[PHV]

Take a look at all the TranferXxxx methods of the DoCmd object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Aristarco]

If you want to make the user save the tables in external files, you'll need a common dialog control to open a "Save as" dialog box. Then you'll need the transfer methods as PHV said.

To boldly code, where no programmer has compiled before!