Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Urgent..COPYING a TABLE from SQLServer to ACCESS?

Author  Topic 

Da_Retina
Posting Yak Master

109 Posts

Posted - 2001-12-04 : 06:11:24
How can I do that using a SQL statement that I have to provide in an ADO command?
Thanks in Advance..
It is urgent
thanks again

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2001-12-04 : 07:25:20
couple of possibilities....


1. search here for 'linked servers'...or variations on those 2 words...this has come up before...


2. DTS is used to move/migrate data to/from SQL Server...it can be involved from a Stored Procedure...and other methods...including ADO..I presume....but a search of this site should turn up some examples of same in previous topics.



Go to Top of Page
   

- Advertisement -