Updating Excel info through Access

G

Guest

Guest
I am trying to create an interface in MS Access to easily update an Excel spreadsheet. The spreadsheet is already linked to the Access database. However, any updates that are made in the Access database, result in what I guess is data coruption as the Excel file will no longer open. Any suggestions are greatly appreciated.
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
You'll need to provide a few more details. How exactly is the Access database updating your Excel workbook? Is this 'on-line' or at a certain interval. VBA or not? If so, can you provide code, if not, can you provide details of the link between Excel and Access?

Regards,
D
 
Upvote 0
The database and the spreadsheet are both on a network drive. The spreadsheet was originally created in Excel and then Linked to Access for ease of reporting. No additional code was created. The spreadsheet was simply linked to Access using the link spreadsheet wizard.
 
Upvote 0
Also, the data in Excel is periodically udated manually. When the link in Access is opened, the new data is refreshed in the Access database automatically by viewing the linked Excel file. Any data manipulation in the database is not carried back to the spreadsheet however.
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,255
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top