IMPORT MULTIPLE EXCEL CSV FILES INTO ONE ACCESS TABLE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top