Multiple Excel files into Access

  • Thread starter Thread starter D Zandveld
  • Start date Start date
D

D Zandveld

Hi

I have a series of Excel spreadsheets (only 1 worksheet in each, so they can
be .csv or .xls) that I want to import into an Access table one under the
next.

I want the user to be able to click the button, select the files to import,
and put the data into a pre-determined table (Vendor Data) one under the next.

Before they come in, i'd like to strip out the header record as well.

Where do I start?
 
First, here is a link to an API you can use to allow users to select a file
to import:

http://www.mvps.org/access/api/api0001.htm

Now, to import multiple worksheets into one table, link to the worksheet
rather than import it. Then use an append query to copy the records from the
linked worksheet to you table. Then drop the link and get the next file.
 
Back
Top