CODEWITHSUNDEEP
ms-accessvba
baiapooped
baiapooped

Reputation: 185

ms-access transfertext not functioning

i have already saved a recent import in data tasks and now i am trying to call it automatically:

DoCmd.TransferText acImportDelim, "import1", "temp", "C:\Documents and Settings\agordon\Desktop\ACTIVITYEX.csv"

the error that i am getting is:

the text file specification "import1" does not exist

does anyone know what this error means?

Upvotes: 1

Views: 779

Answers (1)

ray
ray

Reputation: 8699

It's expecting the parameter "Import1" to be a specification name.

If "import1" is not an actual file, then you can just leave this parameter empty and the file should import into table temp (assuming temp is has the same number of fields as your CSV)

Upvotes: 1

Related Questions