February 17, 2005 at 1:08 am
I have an active table in MS Access. How can I link it live to an sql 2000 table? Is it possible?
February 17, 2005 at 1:26 am
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=144&messageid=160892
Check this you may find solution to your problem
what do you mean by active table???
My Blog:
February 17, 2005 at 1:33 am
Hai ,
Using DTS import the table into the SQL server. In DTS mention source as MS ACCESS
and Target as SQL SERVER and select the DB which u want to..
Did I answer ur Question ?
February 18, 2005 at 5:28 am
Following Ramu, once your data is in a table in SQL Server, create an ODBC DSN that connects to the database and in MS Access, when choosing link table, choose ODBC and select the DSN. You can rename it the same name as it was before.
February 18, 2005 at 11:59 am
Or you can use "OPENROWSET" (see BOL).
Signature is NULL
February 18, 2005 at 1:50 pm
If I understand you correctly, you want to join and Access table and a SQL table in Access. If this is what you want to do then:
Create an odbc connection to the sql database.
In Access go to the table objects screen and right click the white space.
Choose “Link tables”
In the dialog look for “files of type” and choose ODBC databases.
Walk through the wizard – you will come to a screen where you can select tables from you sql database. Choose the ones you want and fill in the “Remember Password” checkbox.
The SQL table will appear in Access but remain in the SQL database.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply