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