Import Data into Access DataTable from another Access Database
C#
1
Posts
1
Posters
0
Views
1
Watching
-
I need to be able to import data from 2 different Access tables into similar data tables in another Access database. I want to perform this operation in the quickest manner possible. The DataTable.Merge method followed by an updated command is one possibility. I would prefer, though, to import the data through a SQL statement without using much code. Is there a SQL statement in MS Access that will accomplish this task. Thanks.