Import into Access from Excel

  • Thread starter Thread starter CB100
  • Start date Start date
C

CB100

Hello,
I have 9 tables that that has the same headers that was downloaded from SAP
into Excel. I would like to import these into one table in Access without
having to combine them first. Can someone please give me some ideas. I get
an error when I try to add to the same table and it does not import.
Thank you
 
Hello,
I have 9 tables that that has the same headers that was downloaded from SAP
into Excel.  I would like to import these into one table in Access without
having to combine them first.  Can someone please give me some ideas.  I get
an error when I try to add to the same table and it does not import.
Thank you  
Click to expand...

TransferSpreadsheet is your friend. Create an import specification
when you run the first import. Name and save it. then use it as an
argument in the transferspreadsheet function.

Could you end the suspense and tell us how you tried to import the
spreadsheet, and maybe the errors you got? We cannot see your
database....
 
Import specs are only for TransferText. There is no such thing for
spreadsheets.
The way to do this is use a predefined Access table and rather than import
each spreadsheet, link to at as a table then use an append query to copy the
data into the Access table one spreadsheet at a time.
 
Back
Top