Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Data from SQL Server
Hi
No idea on how to do this. Need to open a recordset from an SQL Server. Basic details: server name Demo Database Accounts Username keyaccounts password fish What code would i need to use? Regards D |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Data from SQL Server
This is the first hit when I Google for:
ado excel ms sql server http://support.microsoft.com/kb/306125 I suppose you didn't know about ADO RBS "David McNaughton" wrote in message ... Hi No idea on how to do this. Need to open a recordset from an SQL Server. Basic details: server name Demo Database Accounts Username keyaccounts password fish What code would i need to use? Regards D |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA: Column Select then Data Select then return to cell A1 | Excel Discussion (Misc queries) | |||
Excel 2003 Error Cannot Locate the Internet Server or Proxy Server | Excel Discussion (Misc queries) | |||
Use VBA to allow you to select a file name from a directory (public drive/server) | Excel Programming | |||
problem updating link from Novell server to windows server #REF er | Excel Discussion (Misc queries) | |||
Select other workbook to select data in a macro. | Excel Programming |