Linking Access 2007 to Excel 2003?

[DwayneS]

I have a new client who is using Access 2007 and Excel 2003. They have never linked access tables and queries to Excel but they need to know how.

Question is, can I link an Access 2007 table to an Excel 2003 sheet or external query with MSQuery? I do not mean export -- I want to LINK.


Dwayne Streeter, CPA, CITP

http://www.cpe-interactive.com

 

[CaptainD]

I don't have Access 2007 but in Access 2000 Menu: "File" - "Get External Data" and select excel in the file type.

Follow the wizard.

 

[DwayneS]

The problem is compatibility. But the connection to 2007 has been solved. MS updated the MS Query drivers for Access 2007. If you get the newest drivers, then you will have an updated driver for Access databases.

I now have the new drivers and I have established a new connection to each of my access 2007 databases.

Dwayne Streeter, CPA, CITP

http://www.cpe-interactive.com