Retrieve data from Excel cell-by-cell (1 Viewer)

mracz001

New member
Local time
Today, 23:21
Joined
Apr 4, 2019
Messages
3
Dear Member,
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
calculating sheet.
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.
For example:
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?
Thank you.
 

theDBguy

I’m here to help
Local time
Today, 14:21
Joined
Oct 29, 2018
Messages
10,803
Hi. Look up Excel Automation. I think that would work for you.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom