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

_______________________________________________________________________________________

Note: This e-mail is subject to the disclaimer contained at the bottom of this message.
_______________________________________________________________________________________



Brad, I have some samples available on line with a few options.
Some folks have had trouble with the zip files, email directly if you do.
open the excel file first, it has all the passwords and instructions in there.

<<http://www.excelyourbusiness.com.au/FormulaHelp.htm#FormulaExcelToAccessTnf>>

cheers
Darryl.


-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Friday, 1 July 2011 4:58 AM
To: Access Developers discussion and problem solving
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
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________________________________________________

The information transmitted in this message and its attachments (if any) is intended 
only for the person or entity to which it is addressed.
The message may contain confidential and/or privileged material. Any review, 
retransmission, dissemination or other use of, or taking of any action in reliance 
upon this information, by persons or entities other than the intended recipient is 
prohibited.

If you have received this in error, please contact the sender and delete this e-mail 
and associated material from any computer.

The intended recipient of this e-mail may only use, reproduce, disclose or distribute 
the information contained in this e-mail and any attached files, with the permission 
of the sender.

This message has been scanned for viruses.
_______________________________________________________________________________________