vba macro using DDE

[Guest]

I'm new to VBA and I need sample macro code to import numerical data in
multiple cells of an Excel spread sheet to an Access database using DDE. Is
that possible?

 

[Steve Schapel]

Jerry,

Have a look at the TransferSpreadsheet action/method in Access. That
may meet your needs. Otherwise, you may need to use Office Automation
to process the data one cell at a time. If so, this is not an Access
macro question, and you would be better re-posting your question to the
access.externaldata newsgroup.