IMPORT MULTIPLE EXCEL CSV FILES INTO ONE ACCESS TABLE

J

johnny_ringo

is it possible to import 2 excel ".csv" files into one access table so that i
can build a query using information from both files at the same time?
 
D

Douglas J. Steele

Sure.

If you're importing them manually, the wizard asks you into what table to
import, and you specify the table as part of the TransferSpreadsheet
command. Simply specify the same end table for both imports.
 
Top