how to link excel and ms access
how to link excel and ms access
Try to be more specific about what you are attempting. Exporting from Access to Excel? A query? A table? Making the Excel file a record source for Access? We need more information to provide you with an acceptable/functional/usable response. Please explain in simple language what you wish to accomplish. Your current explanation is to vague.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Insert a pivot table in excel and select "Use an external data source" and locate your ms access database there..Before doing this make sure that you have created a query to link your data. its easy.
To refresh the data just refresh the pivot table provided the ms access database should be closed while updating the data.
Hope it helps!
Hi all you.
I can hook to access, get data in it to excel and make all reports on excel with the data. If you want, i will guide you.
Hi all you.
I can hook to access, get data in it to excel and make all reports on excel with the data. If you want, i will guide you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks