Append SQL Statement from external database

J

JonWayn

How do you construct an sql to append rows from a table in an external
database into a table of the current database, using DistinctRow and table
aliases in the JET flavor of SQL?
 
R

Rob Wills

The way I normally do this is as follows:

INSERT INTO tblLocal
SELECT DISTINCT Field1, Field2, Field3
FROM [C:\Temp\DB1.accdb].tblForeign

HTH
Rob
 

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

Append Crosstab Query to Existing Table 0
Menu driven PowerPoint presentations 0
Dynamic Naming of Form Button 3
Creating a Search using a combo box and then creating a report. 4
How to remove external organization from Office. 0
Help creating a search form in Access XP 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
sqlite-odbc write conflict 2

Top