Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you code to get SQL Server data from ODBC Connection?
Hello,
I have an Excel application that I've written that is on a local network. It retrieves SQL Server data by creating a connection using "Provider=SQLOLEDB;". It is working so well, they wanted me to create a vpn and let other offices (physically separate buildings) use the application. I've created an ODBC that accesses the data via the vpn. However, I'm not sure of the syntax to retrieve SQL Server data via an ODBC. I've been googling for awhile now. I haven't found an example of querying on a SQL Server in VBA code via ODBC. Anyone know the syntax to create an ODBC connection to SQL Server from Excel 2007? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
[Microsoft][ODBC SQL Server Driver]String data, right truncation | Excel Programming | |||
Changing and Adding data through ODBC connection | Excel Discussion (Misc queries) | |||
Excel ODBC Data Connection | Excel Programming | |||
ODBC Connection | Excel Programming | |||
ODBC connection for insert into SQL Server | Excel Programming |