Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Link Acess with an Excel document

Status
Not open for further replies.

oggsta

Technical User
Jun 22, 2002
41
GB
Does anybody know how to link an access query with an excel spreadsheet, so that when you update either the Excel document or a Access form or query both, both acess and execl are both updated.

Any help much appreciated
 
I've been facing the same challenge. I have an Excel spreadsheet with about 45 columns that I was trying to link to an Access database. The only problem is that when the database gets updated and the data refreshed in the spreadsheet, Excel does not keep the current (before refresh) data with the same rows.

So I wound up converting the spreadsheet and building it in to my Access database. Now the problem is creating a report to fit this nasty query that has 47 fields. I think I'm going to attempt to use the Analyze with Excel feature and see how closely I can get the spreadsheet to look like the original.

I'll let you know what I come up with, but it's a thought for you as well. Jessica Morgan
Fire Fighter Sales & Service Co.
Pittsburgh, PA
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top