calling excel access

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Calling Excel from Access

Calling Excel from Access

resolvedResolved · Low Priority · Version 2003

Mat has attended:
Access VBA course

Calling Excel from Access

How can I get a procedure to run a query and paste the dataset into an excel spreadsheet please?
Thanks.

RE: Calling Excel from Access

This is not urgent. I could just do with a couple of tips/ pointers in the right direction, rather than a full solution.

RE: Calling Excel from Access

Hi Mat,

Sorry for the delay in responding.

There is a good example of this here:
http://www.howtogeek.com/howto/microsoft-office/export-an-access-2003-report-into-excel-spreadsheet/

Hope this helps.

Regards, Rich

 

Training courses

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Compact database automoatically

To ensure optimal performance, you should compact and repair your

Open the Access database or Access project that you want Access to compact automatically.
On the Tools menu, click Options.
Click the General tab.
Select the Compact on Close check box.

View all Access hints and tips


Server loaded in 0.08 secs.