many excel sheets in one access table

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

Guest

I have many excel files containing one sheet in each and i want to append all
these files in a single table in access. could it possible.
Thanks
 
More than likely, yes, you may do that. Use TransferSpreadsheet action to
import the data from a spreadsheet into an ACCESS table.
 
2 scenarios.
1- first import the first spreadsheet into a NEW table. Verify the table
after to make sure all datatype are correct. Then import all the other
spreadsheets into the first created table
2- Create links to all those spreadsheet. Create a query form one as a Make
Table query. Then run queries as append against the other links.

PS. Check your datatype, sometimes during an import the data in excel may not
be properly formated or there is incorrect data in on of the columns.
 
The data you have coming from the many Excel files may not be in a form that
best uses Access' features and functions. Data in Excel tends to be "flat".
For best use of Access, your tables need to be "relational".

As other responders have pointed out, it is possible to do what you ask.
But that might be only the first step...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top