Advice: Importing data into Access Table

T

Terri Pecora

Assuming you can link to the external system and link to
your SQL Server tables through access. If there is a
common key between the two, then you can write an insert
query to append the records that don't exist in the SQL
Server table.

Thanks
Terri
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
Linking data in MS Word into Excel 5
Importing And Comparing A Table From Excel 0
linking to SQL Server db table 6
automatically creating table links in access to new tables in sqlserver database 1
Data Defnition Query 1
Access to SQL 4
query links to SQL server and mdb table 1

Top