Exporting Data From Query Into Excel

R

Ronald Dodge

How can I have this process automatically done to have the data from a query
after it's been ran to be exported into Excel in a specified location?

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000
 
R

Ronald Dodge

I have done some research on this method. While this method looks
promising, there's one limitation. It states one MUST leave the "Range"
argument as blank, when exporting data. The other thing I'm looking for,
putting data from a query into a worksheet, which the name of the worksheet
would be different from the name of the query. Based on the various things
I have seen with the research I have done, it looks like both names are
required to be the same to use this method, which then breaks up my naming
conventions.

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Queries 3
Parameter In Operator 3
Opening Form without data retrieved 16
DAO Yes/No Boolean values on the Value property of a Field object 3
Declaring a collection as a particular type of object or a particular class 1
Query Key 3
How do you get a parent collection object to listen to all if it's child objects? 5
Merging from an Excel file with graphics 1

Top