Importing specific MS Excel cells into MS Access Table

[Evert]

Hi all,

I am stuck and I need some help. The idea is to automatically collect data from an Excelsheet report that is being distributed multiple times per day. In this report there are only specific adresscells I am interested in. Therefore these need to imported into one MS Access table with each field representing a cell. In time this should build up to a complete table which I need for my analysis.

Example:
In xls file Wavehandover, the following cells need to be captured
cell 1: location column 2, row 4
cell 2: location column 5. row 3
cell 3: location column 7, row 8

Import data of cell 1,2,3 into Mytable field 1,2,3

This should be done repeately untill the directory which the Excel files are stored is fully captured. May be a long story, but is this doable?

[ADezii]

Hi all,

I am stuck and I need some help. The idea is to automatically collect data from an Excelsheet report that is being distributed multiple times per day. In this report there are only specific adresscells I am interested in. Therefore these need to imported into one MS Access table with each field representing a cell. In time this should build up to a complete table which I need for my analysis.

Example:
In xls file Wavehandover, the following cells need to be captured
cell 1: location column 2, row 4
cell 2: location column 5. row 3
cell 3: location column 7, row 8

Import data of cell 1,2,3 into Mytable field 1,2,3

This should be done repeately untill the directory which the Excel files are stored is fully captured. May be a long story, but is this doable?

Try the following Method(s). In Excel:

1. Select the specific cells to be included in a Named Range via the CTRL key
2. Insert, Name, Define
3. Add a Range Name then OK
4. Save the Excel Spreadsheet containing the Named Range
5. Close Excel

Open the Access Database you are using for the Import:

1. File, Get External Data, Import
2. Files of type Microsoft Excel (*.xls)
3. Select Show Named Ranges, Next
4. Select into a New Table

This has not been thoroughly tested, but it is worth a try.