Hi,
I have an Excel file that contains an OLE DB QUERY as an external DATA Connection. I would like to manipulate the data coming from that connection and join them to other Data that I have in an Access Database.
How (if possible) can I simply copy the connection to add it as as linked table in Access so that I can make Queries with all the tables afterward?
I am new to Access. I have some experience with Microsoft SQL Server but I am very poor at setting up connections.
Thanks,
Frederic