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
 Transact-SQL (2000)
 Access Data from MS-Access

Author  Topic 

sanjay_jadam
Yak Posting Veteran

53 Posts

Posted - 2005-12-06 : 08:56:12
How can i access data from MS-Access using SQL query in SQL Server 2000 ??

ditch
Master Smack Fu Yak Hacker

1466 Posts

Posted - 2005-12-06 : 08:59:57
This is a cross post
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=58653

anyways like i said in the other post Use Books OnLine and look up "OPENROWSET"

Duane.
Go to Top of Page

sanjay_jadam
Yak Posting Veteran

53 Posts

Posted - 2005-12-06 : 09:06:03
thanks I done it
Go to Top of Page

ditch
Master Smack Fu Yak Hacker

1466 Posts

Posted - 2005-12-06 : 09:09:00
Great! Now looking at all your other questions that you posted in the last hour or so - I garantee you - that you will find the answers using Books OnLine and Google.


Duane.
Go to Top of Page
   

- Advertisement -