Import data from MS SQL 2000 to MS Access

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

Import/Export (DTS) and Replication (2000)

Import data from MS SQL 2000 to MS Access

Author

Topic

daipayan
Posting Yak Master

181 Posts

Posted - 2009-05-14 : 11:14:11

I have two tables in MS SQL 2000 database name: TABLES and its tables name are:

first_table:
first_ID (varchar (10))
first_password (varchar (20))
second_table:
second_ID (varchar (10))
second_password (varchar (20))

Now I have a MS Access database name: BACKUP and its has one table name:

both_table:
login_ID
password

I want, whenever data is being inserted in both tables of MS SQL, automatically data will be updated in MS Access both_table.

Is this possible???
Please help!!

Daipayan

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-05-14 : 11:31:37

you need to write a trigger and inside this use OPENROWSET or OPENQUERY if linked server connection is present to insert data to access table.

daipayan
Posting Yak Master

181 Posts

Posted - 2009-05-16 : 10:01:20

quote:
Originally posted by visakh16

you need to write a trigger and inside this use OPENROWSET or OPENQUERY if linked server connection is present to insert data to access table.

How to do this?
Am not getting!

Daipayan

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-05-16 : 14:43:21

http://msdn.microsoft.com/en-us/library/ms190312.aspx

daipayan
Posting Yak Master

181 Posts

Posted - 2009-05-20 : 10:13:44