Running Access Reports/queries from Excel

G

Guest

I need to pull in an access Report or Query into an Excel worksheet.

I have read the help about it and install the Microsoft Access Links module.

However I am a bit lost on the syntax I need in Excel.

Basically I have a structure excel worksheet that is currently maunally
updated and wish to plug an automated (ODBC) Access report/query to do the
job.

Kindest Regards

Jai
 
B

B_A_R_T_M_A_N

I would use object automation. You can pass data to cell names in
Excel. If you need a sample, reply to this with an email address and
I will send you one.
 

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

Top