ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   ODBC Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/170336-odbc-excel-2007-a.html)

Jon Kreiss

ODBC Excel 2007
 
I can't get external data with an ODBC connection to SOTAMAS90.

I can bring a XL 2003 to XL 2007 with the functionality intact from 2003
spreadsheet - but I can't create a functional XL 2007 new query.

Are there any sources for guidance?

Thx.


Jim Cone

ODBC Excel 2007
 

Maybe this will be of some help...
"Managing External Database Connections in Excel 12"
http://blogs.msdn.com/excel/archive/...16/533865.aspx
(it even has pictures)<g
Just don't ask me any questions - I don't have xl2007.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Jon Kreiss"
wrote in message
I can't get external data with an ODBC connection to SOTAMAS90.

I can bring a XL 2003 to XL 2007 with the functionality intact from 2003
spreadsheet - but I can't create a functional XL 2007 new query.

Are there any sources for guidance?
Thx.


Jon Kreiss

ODBC Excel 2007
 
This looks like a good starting point. Thank you.

"Jim Cone" wrote:


Maybe this will be of some help...
"Managing External Database Connections in Excel 12"
http://blogs.msdn.com/excel/archive/...16/533865.aspx
(it even has pictures)<g
Just don't ask me any questions - I don't have xl2007.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Jon Kreiss"
wrote in message
I can't get external data with an ODBC connection to SOTAMAS90.

I can bring a XL 2003 to XL 2007 with the functionality intact from 2003
spreadsheet - but I can't create a functional XL 2007 new query.

Are there any sources for guidance?
Thx.




All times are GMT +1. The time now is 10:35 AM.

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