Hi,

Thanks for your reply.

Yes, I concluded the same after 4 hours of crawling on Google.

This is what I have structured:

I have 10 remote sites inputting the data in 10 different excels. This excels are imported / updated to my local sever using Google Drive! I know its a cheap / unreliable option as I cant afford a proper server right now with a VPN. Having this option I decided to have another layer of backup on my local drive which imports the data of these 10 excel files into one using the links, but know as 10 different databases are imported into one, the file becomes big and slow and also increases the chances of data corruption. So I wanted to have another file which will be used to query the backup database without opening the backup file.

Now I believe I am left with only 2 options one I use the same backup file (over the network) for querying the database or I put VB code to open the backup file, update links and close it.

Any suggestions?

Thanks.