How do i go abouts taking data from a table in access and dumping it onto a sheet in excel.
Printable View
How do i go abouts taking data from a table in access and dumping it onto a sheet in excel.
Create a recordset of the data you want to dump into Excel, and then use the CopyFromRecordset method of the Workbook object to port it to your spreadsheet.
Also, if you want to do it automatically then you can execute the menu - Tools > Office Links > Analyze it with MS Office Excel.