Thread: accessing SQL server from Excel/VBA (instead of ODBC)
View Single Post
  #1   Report Post  
Posted to microsoft.public.office.developer.vba,microsoft.public.excel.programming
Danut Danut is offline
external usenet poster
  
Posts: 3
Default 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


Reply With QuoteReply With Quote