Forum Discussion
anilachandran
Mar 12, 2019Copper Contributor
Importing a list of files into Excel
I have office 365. I am trying to import access file into excel. In excel i went to data-get data-from data base-from microsoft database and import. But it is not creating a link to the access file w...
anilachandran
Mar 13, 2019Copper Contributor
Hi it imports data but if I go to queries and connection and look for connection for the access file it is not there. There is no existing link to the access file. All it does is uploads the table
JKPieterse
Mar 13, 2019Silver Contributor
Look on the Queries tab of that side pane.
- anilachandranMar 13, 2019Copper Contributor
That is where I was looking in data tab-Queries and connection-in Connection. the access file connection is not there. thanks for helping me
- JKPieterseMar 13, 2019Silver Contributor
I meant this... (see screen-shot)
- anilachandranMar 13, 2019Copper Contributor
That is where I saw and I dont have any connection to the Access file