I am getting very desparate. I've searched through all of the help files and can't seem to find good information for getting data from an excel workbook. The help files in Access and Excel aren't consistent with one another. I've looked at DDE in Access, and found a little information, I've looked at all the help files in Excel and all it talks about is a convert to access or getting data from a database. I need a method for transferring the data, either from within excel to access, or getting data from excel. It needs to be automated so the users only have to click one button. All people aren't smart enough to do the import or link table properly. Any info or direction would be greatly appreciated.
getting data from excel
- Thread starter yeatmanj
- Start date
This is the second time I've asked for information regarding transferring between Access and Excel through VB or VBA. Last time the response I got was that it couldn't really be done. Well since I made this post I've been able to find a little more information on the subject and the following link will take you to some helpful information.
http://www.microsoft.com/ExcelDev/Articles/movs104.htm
http://www.microsoft.com/ExcelDev/Articles/movs104.htm
David Mack
Registered User.
- Local time
- Today, 13:56
- Joined
- Jan 4, 2000
- Messages
- 53
You are probably not getting any replies because this is an Access forum. People stick to Access questions here. You can learn all you need about the Excel automation by examining the Excel Object Model. You will have to open the code window and add the references to the Excel Object Library.
Dave
Dave
You two are funny. This is still modules and VBA. Besides the fact that I am going between access and excel with access as the major controller, I've also found the link at the bottom of the second post that is full of helpful information.
But thanks anyway.
But thanks anyway.
