Export data to and populate an existing Excel spreadsheet

[gtstangman35]

Good Afternoon. I hope someone can help me with this. I working on a project for a client in which they have an existing Excel Spreadsheet that has about 8 fields with about 700 rows of data. I have another user that is storing data into a Access database, and I want this data to be able to export and populate the existing fields on the Excel spreadsheet. How do I do this? There has got to be a way to do this without writing VB code. I am a Network admin, not a programmer so I need help with this one!!

Thanks,
Wes H

 

[perezm1]

You have to select the table you want to export from Access. Once you have selected it, then you select file, export and choose the version of Excel you want it saved as. Then you go to Excel and you open the file.

I hope this works,

Miguel

 

[gtstangman35]

Thanks for the reply! I tried that, and it will export, but it makes a new workseet inside the existing workbook. I want it to update an existing worksheet, how do I do that?

 

[gtstangman35]

Also, one more piece to this is. Once the data is imported to the Excel I need the user to then be able to input new data to the Excel spreadsheet and then push the changes back to the database. How should I do that?

-Wes H