Hi

I have a system which imports data from text files on a weekly basis.

I have created links to the text files (which should come in an consistent format). My plan is to simply overwrite the text files (e.g. names and locations remain the same) when new ones become available and then kick of a routine which runs a number of queries to extract the data and update the system accordingly. I.e. I will not create new links, but leave the existing links as they are. The only change is that the text files themselves are replaced.

In a recent test, when the text file was overwritten, Access failed to read it correctly, showing only one row of data (there are over 500,000) contain wacky character sets. There was nothing wrong with the file itself and when I deleted the existing link to the file and recreated it, everything worked fine.

Has anyone here tried setting up something similar? Would I be better advised to delete the existing links and recreate them each time a new set of files arrives? Or is my current approach reasonable? As I say, the files should be identical in format every week.

Thanks
Paul