View Full Version : Export Report to PreExisting Excel Document


ahall1
03-18-2002, 10:53 AM
I am currently building a database to track and order supplies for my company. I have specific company forms that I must use when ordering supplies, which leads me to this question. Is it possible to export the data from a report into an existing excel document?

Pat Hartman
03-18-2002, 07:12 PM
Yes. But if the spreadsheed is not a datasheet format, you will need to write code to do it. It would be easier to take a copy of the spreadsheet template and modify it to import the data from Access.

jekirksey
07-30-2002, 07:06 PM
using the data tools in Excel you can actually link a spreadsheet to a database in go to Data/Get External Data and New Database Query, it's pretty easy to walk through if you have good knowledge of Access and Excel. The first time you open the workbook after saving it it will prompt you to update the information, just select "always refresh without asking"