By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,988 Members | 1,360 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,988 IT Pros & Developers. It's quick & easy.

How can pass data from access to access unbound object (Excel)

P: 2
I create a form in an Access database and put in an unbound object which the class is Excel. I am going to pass data from the Access database to the object, I try to use Excel function "CopyFromRecordset" to pass data. I don't know how to write VBA code.
Mar 21 '07 #1
Share this Question
Share on Google+
2 Replies


P: 13
I create a form in an Access database and put in an unbound object which the class is Excel. I am going to pass data from the Access database to the object, I try to use Excel function "CopyFromRecordset" to pass data. I don't know how to write VBA code.
Hi Charlie,

I don't write much VBA either (although I have a bit of Pascal and C+ experience). Are you sure you need to embed the Excel object? Could you not get round the problem by simply exporting the data into Excel? My experience has been that once you have created your spreadsheet and all the cells are correctly formatted and the functions working, one can quite simply replace the data by using the export facility on the File menu.

B
Mar 21 '07 #2

P: 2
Hi Charlie,

I don't write much VBA either (although I have a bit of Pascal and C+ experience). Are you sure you need to embed the Excel object? Could you not get round the problem by simply exporting the data into Excel? My experience has been that once you have created your spreadsheet and all the cells are correctly formatted and the functions working, one can quite simply replace the data by using the export facility on the File menu.

B
Hi brynne;

Thank you for your reply.

I am sure I need to embed the Excel object. Did you use the pivot table wizard function in MS Access form (version 97). It is create an embed Excel object and MS Access automatically pass data to the object. You can edit them. While you close the Excel object. Access will automatically save them. That is what I want to achieve.
Mar 22 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.