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
 
Top