How To Maintain "Fresh" Data in Imported Table

[ALewis06]

I was unable to do a link table function for the tables I got from a password protected server but I was able to import the tables I needed & create a parameter query and subsequent search form from that. However each month I need to be able to go back and refresh the data from the server; since I wasn't able to establish a link what's the best way to do that? Can I automate the process via macro?

Using Access 2010

 

[Trevor G]

What about asking the Server Administrator (the can write this into the server) to download the file into a Folder and it overwrites the previous month of data or you can then use a small amount of code to do the transfer for you and delete the previous data and refresh with the next set of data.

 

[ALewis06]

I will give it a shot, thanks.