Load Excel sheet on VB6 form, then save it to a MDB.
Posted on 2005-04-08
I use VB6, and an access database using DAO (I know its old but the application is old too. I will soon migrate to the "new" ADO... I hope so...)
Well, I have a record that includes some fields, but I want to add an excel sheet to each row.
Because I need to add special information to each costumer... graphics, tables, etc. And the best solution is to add an excel sheet to each costumer and personalize each document and keep it inside the MDB (Access database.)
I do not know if I would require an special component, or an Office version on each target machine.
I do know how to save a picture to an OLE field, so maybe I could use the same to save it to the MDB.... but.... how can I load it on the form?
(If anyone wants the way to save to an OLE field, just ask.)
And If anyone knows what to do with the loading-xls file to the form, please tell me. I'd like to have some toolbars and stuff available.
Thank you all,