Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,452
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA: Column Select then Data Select then return to cell A1 James C[_2_] Excel Discussion (Misc queries) 3 February 1st 10 11:35 AM
Excel 2003 Error Cannot Locate the Internet Server or Proxy Server Seabee Excel Discussion (Misc queries) 0 November 20th 05 12:03 AM
Use VBA to allow you to select a file name from a directory (public drive/server) turnerje[_2_] Excel Programming 2 September 27th 05 08:03 PM
problem updating link from Novell server to windows server #REF er Ellen Excel Discussion (Misc queries) 0 May 10th 05 09:18 PM
Select other workbook to select data in a macro. T Tromp Excel Programming 2 September 19th 03 01:43 PM


All times are GMT +1. The time now is 08:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"