Mar 12 2019 05:24 PM
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 which is what I need. What do i do to have a link to that file
Mar 12 2019 11:54 PM
Mar 13 2019 08:29 AM
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
Mar 13 2019 10:31 AM
Mar 13 2019 10:39 AM
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
Mar 13 2019 10:51 AM
I meant this... (see screen-shot)
Mar 13 2019 11:03 AM
Mar 13 2019 11:13 AM
That is where I saw and I dont have any connection to the Access file
Mar 14 2019 03:03 AM
Mar 14 2019 08:56 AM
I found a way. I went to Data tab-Existing connection-Browse for More and chose the file. It uploaded the table as well as made a connection. thank you so much for your replies