Linked Table filename is mixed up

[hazelett]

I have an Access 2007 database that has links to 38 excel files. The Excel files are recreated every month with the same filenames which overwrites the previous data. The idea was that since the filenames are the same, Access would find the files with the new info and be linked automatically. The filename in the linked table manager isn't completely right. Instead of C:\excel\fileone.xlsx it is C:\excel\fileone.xlsx\filetwo$. If I delete the link in Access and recreate it, it will show up as c:\excel\fileone.xlsx\fileone$ and will work. Refreshing the links in the linked table manager does not help. Where does that \fileone$ at the end of the filename come from and what does it mean. I only want to link to the excel files long enough to append them to a single access table. Any ideas would be much appreciated.