Updating Excel info through Access

Mar 8th, 2002, 01:15 PM

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.

dk · Mar 8th, 2002, 01:17 PM

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

Mar 8th, 2002, 02:06 PM

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.

Mar 8th, 2002, 02:11 PM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 8th, 2002, 01:15 PM	#1
Guest Posts: n/a	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.

Mar 8th, 2002, 01:17 PM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	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

Mar 8th, 2002, 02:06 PM	#3
Guest Posts: n/a	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.

Mar 8th, 2002, 02:11 PM	#4
Guest Posts: n/a	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.