inserting data from sql server to access

[Neil Hughes]

I have two server one with an sql server running and another with an
msaccess, i'd like to run an sqlquery in asp from the msaccess server.

The msaccess server has a system dsn called sqldsn

how do i run an sqlquery to copy all the contents from the sql server t othe
msaccess database (access is opened via jet) i don't have ms access on the
machine so i cannot use linked tables.

so far i have,

INSERT INTO tablename SELECT * FROM
[odbc;DSN=sqldsn;UID=user_id;PWD=password].tablename

however this doesn't work, any ideas?

 

[Jerry Boone]

Look into using DTS (Data Transformation Services), a feature of Sql server
accessible using Enterprise Manager. It handles this stuff very nicely...

--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz
Secure Hosting and Development Solutions for ASP, ASP.NET, SQL Server, and
Access