Invalid Argument when importing .csv into Access 2007 DB using a Macro

[Jason C]

Hi all, newbie to this forum here. I've got a predicament that I am working on. We have an access database (.mdb) and I am trying to use a Macro we created that imports a few lines of Import Delimited text from a .csv file. Everything works just fine on a Windows XP computer, but when running the Macro on a Windows 7 PC, I get a message stating "Invalid Argument" and the records do not get imported. We tried the Compact and Repair tool with no resolution. Here is my Macro:

 SetWarnings - No; OpenTable - AddressInfo, Datasheet, Edit ; TransferText - Import Delimited, Current Import Specification, AddressInfo, C:\UPSInv\Current\Current.csv, No, , 50001 ; RunSQL - UPDATE AddressInfo SET Addressinfo.PackageType = "Standard Flats" ; SetWarnings - Yes ; CloseDatabase

Anyone have any ideas? Much appreciated! Thanks!

[qa12dx]

since ur file is formated the same, why dont u just link to file to ur db. everytime u have a new file all u have to do is replace the old file. and then run ur qry and stuff.

[tanvi]

Check this post: http://answers.microsoft.com/en-us/o...6-204bd3737eb1
Hope it will work for you to resolve the issue!!