My solution is to link to the file each day, import the data, then delete the link.
What I can't figure out is how to do the link...
I'm trying this:
Code: Select all
DoCmd.TransferText acLink, , "tblTempComments", CurrentDBDir & "Unclassified\" & strDateToUse & "-Unclassified.csv", True
3011 - Access can't find the obect tblTempComments
I'm sure it's a simple syntax misstep, but I can't figure it out.
Also, for some strange reason the file deletes after each attempt to run the code.
Any suggestions? The path to the file is correct....I've triple checked.