Go Back   Access World Forums > Apps and Windows > Visual Basic

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-11-2019, 05:29 AM   #1
mracz001
Newly Registered User
 
Join Date: Apr 2019
Posts: 3
Thanks: 3
Thanked 0 Times in 0 Posts
mracz001 is on a distinguished road
Retrieve data from Excel cell-by-cell

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.

mracz001 is offline   Reply With Quote
Old 11-11-2019, 05:32 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,593
Thanks: 58
Thanked 1,444 Times in 1,425 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Retrieve data from Excel cell-by-cell

Hi. Look up Excel Automation. I think that would work for you.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
mracz001 (11-13-2019)
Old 11-11-2019, 05:36 AM   #3
Gasman
Enthusiastic Amateur
 
Gasman's Avatar
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 4,545
Thanks: 442
Thanked 847 Times in 818 Posts
Gasman is a jewel in the rough Gasman is a jewel in the rough Gasman is a jewel in the rough
Re: Retrieve data from Excel cell-by-cell

Sounds like you will kow exactly which cells you need to refer to?

Have a look at this thread.

http://www.utteraccess.com/forum/lof.../t1983041.html

__________________
Access novice. Sometimes trying to give something back.
Access 2007

Please, please use code tag # when posting code snippets

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Gasman is offline   Reply With Quote
The Following User Says Thank You to Gasman For This Useful Post:
mracz001 (11-13-2019)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Import excel data to access cell by cell russmann2000 Modules & VBA 8 03-26-2018 02:12 AM
Get Cell RGB Color of Excel Cell with VBA Function Rx_ Code Repository 0 05-04-2015 08:44 AM
lock cell in subform unless cell in form has data in it holden_1 Modules & VBA 4 09-29-2008 11:58 PM
How to create Excel sheet cell by cell accesser2003 General 1 09-05-2007 01:55 PM
How to Retrieve Excel cell contents using path created from Access Data? boomfox General 1 12-11-2003 07:12 AM




All times are GMT -8. The time now is 10:45 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World