Connecting to MSSQL server via VBA

[satchi]

Hi, I'm relatively new to VBA but know basic SQL, VB, etc. I have a remote MS SQL server 2000 database that I want to connect to via Access (2000). My question is, how would I go about to setting up a connection to the SQLserver database, and then copy the table onto an Access table?

I know I need to set up an ODBC link, but not really sure how to begin. Any suggestions is appreciated. Thanks!

 

[ZmrAbdulla]

here is the manual way of doing it.

http://support.alentus.com/access_linking.aspx

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[Remou]

I think this will help:
Connecting to DB on remote server with ODBC
thread333-1251424

 

[satchi]

Thanks for the replies. I know a little more about how connections between Access and my MS*SQLserver works.