IMPORT MULTIPLE EXCEL CSV FILES INTO ONE ACCESS TABLE

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

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

Add .csv File Name When Importing Multiple Files Into a Table 0
Access Importing csv daily files into access 2007 1
CSV Import Error 2
Csv import: direct link vs temp table dump 2
Cannot Import .CSV Files - Option Not Available in Drop Down Box 23
How to import multiple CSV files into single Excel spreadsheet 1
import csv conversion & import spec error 1
importing files that increment daily 5

Top