Using ADO to import CSV into Access

[RichardMGreen]

Hi all

I've got the following line of code that's throwing out an error.
conn.DoCmd.Transfertext acImportDelim, , loadtable, keepname, True

I've set up conn as the ADO connection to the database and it's supposed to import a CSV into loadtable using the file keepname.

I'm using Option Explicit to ensure all variables are pre-designed but the acImportDelim is throwing an error as not defined.

Two questions:-
1) Am I doing this correctly?
2) If so, what should acImportDelim be defined as?

 

[Weaver]

Are you running this code in Excel?

If so, it won't have a value for acImportDelim unless you have the correct reverences.

replace it with 0 or define acExportDelim as a constant with the value of 0 elsewhere in your code.

 

[RoryA]

DoCmd and acImportDelim belong to Access not ADO. You would have to create an Access.Application object to use that.

 

[RichardMGreen]

Thanks guys, looks like a bit of a rethink is required.