Excel and Access data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dan - 29 May 2004 15:07 GMT

How can I programatically export data from Access to a selected file and
worksheet? Can do macro or VBA.

(I can do the export but I can't find a way to address the worksheet.)

Thanks.

Reply to this Message

Andy Wiggins - 31 May 2004 12:10 GMT

In Access you can use the TransferSpreadsheet action to import or export
data between the current Microsoft Access database (.mdb) or Access project
(.adp) and a spreadsheet file.

Signature

Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"

> How can I programatically export data from Access to a selected file and
> worksheet? Can do macro or VBA.
>
> (I can do the export but I can't find a way to address the worksheet.)
>
> Thanks.

Reply to this Message