Thread: Process data in a sheet within workbook using SQL query?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jamie Collins Jamie Collins is offline
external usenet poster
  
Posts: 593
Default Process data in a sheet within workbook using SQL query?
"Stevie_mac" wrote ...

Is it possible to do my queries directly to SQL Server without
a DSN (i.e. using a connection string)?

You can use ADO with a DSN-less connection string e.g. using OLE DB
provider:

http://www.able-consulting.com/MDAC/...erForSQLServer

Jamie.

--
Reply With QuoteReply With Quote