Import multiple excel sheets into one table

[Mi]

Hello,
I have problem linking to an excel workbook. I have to use a sheet for each month data due to the size of the data, thus 2005 workbook with 12 sheets. There are 2 different workbooks with similar data. I had imported the sheets and did the needed qry's before realizing that the size of the excel was going to be a problem. Is there a way to do this?

Please help!!!

Mi

 

[spazmonkey]

Sorry, not sure what you mean here.

You can Link to a Range of Cells or an entrie Worksheet. If you would like to link to a range this can be done by

1)Selecting the excel range of cells with (hopefully) Field Names as column Headings in the first selected row.

2) Choose Insert|Name|Define and give the selection a name.

3) Link from Access using the get External Data wizard and your Defined Range will be there.

If you are not talking about linking but you are talking about compiling all of your worksheets into one table...

1) Create one tabel with all the fields/Data types that are common to all tables.

2) Use Append Queries to append from your imported/Linked Tables/Ranges into your main table.

If you have matching Field names you could also use a Union Query (SQL) which just places one table on underneath another.

Hope This Helps?

 

[Mi]

I will look into this. I have not tried using Append Queries before.

Thanks to direction :wink:

Milia