Retrieve data from Excel cell-by-cell
I have a task, that I am not able to solve.
Perhaps you can help me.
The facts are:
There is a spreadsheet in Excel.
This sheet does not contain records, this is a
I must import some cells into one record in Access.
In other words:
I do the calculations in Excel, then I want to import some results
into an Access table in one record.
The same calculating Form would be time consuming to
program in Access.
Excel -> Access
A1 -> Field1
C22 -> Field2
D5 -> Field7
The access record will contain another data too, which
are entered via an Access Form.
Can you please help in this problem?