error when importing .csv

[llaman]

"the text file specification "0" does not exist. You cannot import, export, or link using the specification"

I am not sure what is causing this error, but here is the relevant code

DoCmd.TransferText acImportDelim,acSpreadsheetTypeExcel4, arg1, "H:\Time_Tracking\MasterReport\" & arg1 & ".csv"'



Also, why is this statement not allowed: (i must comment it out to run)

DoCmd.RunSQL (INSERT INTO arc_entries_ENG (userid, entrydate ...)
SELECT userid, entrydate,.... FROM entries_ENG)

 

[Norie]

The number/type of arguments you are using is wrong.

From Access Help:

DoCmd.TransferText [transfertype][, specificationname], tablename, filename[, hasfieldnames][, HTMLtablename][, codepage]

You appear to have transfertype twice -

ImportDelim, acSpreadsheetTypeExcel4

 

[llaman]

I took the "acSpreadsheet......" out and it now gives me the error that the method requires a filename argument. Perhaps it was not the problem?