I recently have come across Run-time error '3349' when I try to import a .csv file using MS Access 2010. While I was developing my DB I had everything in one DB and it worked fine. I just split my DB into a front end and back end.....Now I get the run-time error when I try to execute the below code. I've looked around and the general solution I have found is to link to the .csv file. I would rather not do that as I am archiving the file each week and replacing with a new .csv file. Any suggestions on this? Thanks in advance.
Code:
DoCmd.TransferText acImportDelim, vImportSpec, vTableName, vFolderLoc