exporting to excel sample DB

[soundsfishy]

I found this great little DB that imports data form excel to a DB. What I would like to do is the opposite by using a the record set from a query.

Ideally whatI'd love to do is export the records from the query into a specified xls sheet that that dont already exist in the spreed sheet.

 

[Fuga]

To export a query to excel you can use this line.

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, "name of query", "c:\dir\file.xls"

Fuga.

 

[soundsfishy]

thanks, I'll give that a try.

 

[Pat Hartman]

The TransferSpreadsheet Method/Action does not allow you to specify a destination within a file. To put your data to a specific sheet or range, you'll need to write automation code.