inserting data from sql server to access

  • Thread starter Thread starter Neil Hughes
  • Start date Start date
N

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?
 
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
 
Back
Top