Running an insert query on a remote db

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

Is it possible to run an access query to insert records in an access table
from a table in a remote sql server db?

Thanks

Regards
 
The simplest way is to link to the SQLS table just like it was an Access
table. Click on File>Get External Data>Link tables. Scroll down teh File
type dropdown to the last choice - ODBC database. A wizard will open to help
you build an ODBC connection.

Once the table is linked, you can use it like any other table provided your
connection has the necessary permissions.
 
Thanks. Is there any IN option in Access sql like below?

SELECT id, name, [date]
INTO LocalTable
FROM RemoteTable IN [Data Source=<ip address>;Initial
Catalog=RemoteDB;Persist Security Info=True;User
ID=;username;;Password=password]

Thanks again

Regards
 
Back
Top