Search results

WooHoo! Figured it out: :) The Access tables must retain memory concerning datatypes. For whatever reason, importing via the DoCmd.TransferText method only works for datatypes = to Number (Long Integer) or Text. Even though importing manually with other datatypes (decimal, memo) works, it...

No dice, same error message 3001 invalid argument. Plus, the code worked previously, it was only after I made changes to the table that it stopped working. I even deleted the table and started from scratch...

I did, several times... The kicker is that I can upload text files manually using the same table & spec file, it just doesn't work running the code. Thanks for the reply! Any more advice?

I never changed the code, but deleted/ recreated a new table and changed some of the datatypes. I'm sure the problem is with the spec file, since the first time I tried coding this, I had trouble and it wasn't until I redid the spec file over & over before it worked (never figured out the...