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

[Charlie Xu]

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.

[brynne]

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

[Charlie Xu]

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.