T tracey Oct 16, 2003 #1 I need to export data from access to specific cells in an excel spreadsheet. any idea where I can get more info on this?
I need to export data from access to specific cells in an excel spreadsheet. any idea where I can get more info on this?
J John Nurick Oct 17, 2003 #2 Hi Tracey, You'll need to use VBA and Automation. The following links should get you started: Sample Excel automation http://www.mvps.org/access/modules/mdl0006.htm Q123859 ACC: Sample OLE Automation for MS Word and MS Excel http://support.microsoft.com/?id=123859 ACC2000: Using Automation to Create and Manipulate an Excel Workbook (Q210148) http://support.microsoft.com/?id=210148 ACC: Using Automation to Create and Manipulate an Excel Workbook (Q142476) http://support.microsoft.com/?id=142476 There's a white paper and code samples including tutorials available from Microsoft at http://support.microsoft.com/?id=253235 Also, search www.mvps.org/access for Excel Automation
Hi Tracey, You'll need to use VBA and Automation. The following links should get you started: Sample Excel automation http://www.mvps.org/access/modules/mdl0006.htm Q123859 ACC: Sample OLE Automation for MS Word and MS Excel http://support.microsoft.com/?id=123859 ACC2000: Using Automation to Create and Manipulate an Excel Workbook (Q210148) http://support.microsoft.com/?id=210148 ACC: Using Automation to Create and Manipulate an Excel Workbook (Q142476) http://support.microsoft.com/?id=142476 There's a white paper and code samples including tutorials available from Microsoft at http://support.microsoft.com/?id=253235 Also, search www.mvps.org/access for Excel Automation