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.
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.