Excel retriving reports from Access

[George]

I am creating a macro in an
Excel file, this macro should ask the user what report
from a specific Access database he wants to analyze in the
excel file. I already have the form to ask the user what
reports he wants to see, now I need to create a code that
retrieves the report from the specific database. Thanks

 

[JulieD]

Hi George

i've checked out my Excel 2002 Power Programming with VBA book (John
Walkenback) and it has an example where you can use ADO to retrive data from
a table in Access. Now i don't know if you can use the same method to
access data from a query (i'm guessing it's possible) but i'll be VERY VERY
VERY surprised if you can access information directly from a report using
any method at all.

I'm not sure if i'm allowed to type out the code from the book here - but
it's a great book to have on your shelf anyway - so check it out it's on
page 619.

If someone (John maybe - does he read these groups?) says its okay for me to
post the code, then i will.

Cheers
JulieD

 

[George]

Thanks for anwsering my post, I have a code here for
retriening data from tables (ADO), I dont know if is the
same as the one in the book but I am trying to use this
one and it gives me a compile error: Expected Identifier;
highlighting the database
address "C:\FolderName\DataBaseName.mdb". If you want you
can write to my e-mail and let me know if you have
something that I can use to solve this problem. Thanks
again

 

[JulieD]

Hi George

one of the notes in the book i have is that the code requires a reference
(tools / reference in the VBE) to Microsoft ActiveX Data Objects 2.x library

have you got that reference checked?

Cheers
JulieD

 

[Dick Kusleika]

George

Check my reply to your previous post and let me know if I missed the mark.