query to excel (1 Viewer)

kitty77 · Oct 22, 2019

How do I run a query then have it create a excel file? Macro? VBA?
Without doing it manually?

theDBguy · Oct 22, 2019

Hi. You should be able to use either one, but I prefer to use VBA.

pbaldy · Oct 22, 2019

TransferSpreadsheet and OutputTo are the two most common/easiest methods. I use VBA but I think both are macro actions too.

kitty77 · Oct 22, 2019

I'm using this, it works but it exports it as if you checked off to export with formatting. Can I change that?

DoCmd.OutputTo ObjectType:=acOutputQuery, ObjectName:="sales", OutputFormat:=acFormatXLS, Outputfile:="C:\aaa\test.xls"

theDBguy · Oct 22, 2019

kitty77 said:
I'm using this, it works but it exports it as if you checked off to export with formatting. Can I change that?

DoCmd.OutputTo ObjectType:=acOutputQuery, ObjectName:="sales", OutputFormat:=acFormatXLS, Outputfile:="C:\aaa\test.xls"

Try TransferSpreadheet. I think it doesn't format the data.

kitty77 · Oct 22, 2019

Can you give me an example using mine?

Thanks...

kitty77 · Oct 22, 2019

I got it! Thanks for that.

theDBguy · Oct 22, 2019

kitty77 said:
Can you give me an example using mine?

Thanks...

Code:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "sales", "c:\aaa\test.xlsx", True

theDBguy · Oct 22, 2019

kitty77 said:
I got it! Thanks for that.

Oh, you got it. Good. Glad to hear you got it figured out. Good luck!

query to excel (1 Viewer)

kitty77

Registered User.

theDBguy

I’m here to help

pbaldy

Wino Moderator

kitty77

Registered User.

theDBguy

I’m here to help

kitty77

Registered User.

kitty77

Registered User.

theDBguy

I’m here to help

theDBguy

I’m here to help

Similar threads

Users who are viewing this thread