Query to export data to excel 2

[FeS2]

Is there a way to use a query to retrieve data from a table and then export it straight to Excel 2000 spreadsheet. It will have to create the spreadsheet when the query is run. Thanks in advance.

 

[KenReay]

Hi

see docmd.transferspreadsheet in help, with this command tou can import or export an excel spread sheet Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[watty215]

Try this line of code


DoCmd.OutputTo ouputQuery, "Your Query", "MicrosoftExcel(*.xls)", "C:\Your File.xls", True, ""

Hope it helps

 

[FeS2]

Thank you. The code worked great!

 

[cuok]

And by this code you can dend the table by e-mail, i think i got this code from KenReay !!


DoCmd.SendObject acSendTable, "TblName", acFormatXLS, "eliahu@cuok.co.il", "solutions@cuok.co.il", , _
"Current Spreadsheet of Biochemistry", , False


CUOK

 

[JR2913]

As suggested by Ken the cmd.transferspreadsheet is an alternative command that can be used, e.g.

DoCmd.TransferSpreadsheet acExport, , "Queryname", "c:\Your Filename", True, ""


No need for the file extention in the file name as this command has defaulted to Excel version 8.

Works for me!

JR