ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   DB connection 2003 vs 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/164139-db-connection-2003-vs-2007-a.html)

Jordan

DB connection 2003 vs 2007
 
In 2003 to import external data I used;

Import External Data
New DB Query
Choose Data Source

From here it allowed me to connect fields from different tables and create a
report.

I can not figure out how to do this in 2007. Any help will be greatly
appreciated.




Roger Govier[_3_]

DB connection 2003 vs 2007
 
Hi

Take a look at DataGet External DataFrom Microsoft Query

--
Regards
Roger Govier



"Jordan" wrote in message
...
In 2003 to import external data I used;

Import External Data
New DB Query
Choose Data Source

From here it allowed me to connect fields from different tables and create
a
report.

I can not figure out how to do this in 2007. Any help will be greatly
appreciated.







All times are GMT +1. The time now is 12:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com