Running Access Reports/queries from Excel

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
Back
Top