| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.office.developer.vba,microsoft.public.excel.programming
|
|||
|
|||
accessing SQL server from Excel/VBA (instead of ODBC)
I added some VBA code into an excel Spreadsheet to get some data from a SQL
server using QueryTables and ODBC (I defined a DSN, etc.). Is there a faster method to access SQL Server (ADO)? Note: I am a beginner in VBA. Thanks! Danut |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 64 bit ODBC driver for Excel (Server 2008) | Excel Discussion (Misc queries) | |||
| Changing ODBC server (MySQL) | Excel Worksheet Functions | |||
| How easy is it to change the server odbc details for excel | Excel Discussion (Misc queries) | |||
| Multiple people accessing an Excel file from a server at once. | Excel Discussion (Misc queries) | |||
| SQL Server ODBC Error | Excel Discussion (Misc queries) | |||
Threaded Mode
