[AccessD] Pulling Data from Excel into Access with "Automation"

'Steve Goodhall' steve at goodhall.info
Thu Jun 30 15:26:00 CDT 2011



	Yes.   

	Use the Cells collection of a Worksheet object.  So for example: 

	Dim vValue as Variant 

	vValue = oWS.Cells(4,4).Value  

	After that it gets complicated. 

	Regards, 
Steve Goodhall, MSCS, PMP 
248-505-5204

----- Original Message -----
 From:Access Developers discussion and problem solving 
To:"Access Developers discussion and problem solving" 
Cc:
Sent:Thu, 30 Jun 2011 13:57:48 -0500
Subject:[AccessD] Pulling Data from Excel into Access with
"Automation"

All,

I have started to experiment with pushing data from Access to Excel
via
"Office Automation". So far, these tests have gone nicely.

Now, I would like to experiment with pulling data from Excel. I know
that it is easy to simply link to an Excel file and obtain the Excel
data. However, I would like to know if it is also possible to pull
data
from Excel with Automation. For example, let's say that I have an
existing Excel spreadsheet and I simply want to obtain the contents
of
only cell "D4" and pull it into Access. Is this possible?

Thanks,

Brad 

-- 
AccessD mailing list
AccessD at databaseadvisors.com [1]
http://databaseadvisors.com/mailman/listinfo/accessd [2]
Website: http://www.databaseadvisors.com [3]


Links:
------
[1] mailto:AccessD at databaseadvisors.com
[2] http://databaseadvisors.com/mailman/listinfo/accessd
[3] http://www.databaseadvisors.com/




More information about the AccessD mailing list