Transfertext problem

[jandi]

I am using this to try to import a text file "DoCmd.TransferText acImportDelim,

But when it is run gives me error 3051 stating cannot open or write to file it is already open exclusively by another user.

I can import this file manually using the spec file with no problem.

I am the only user using this Db and can write to the folder it is contained in.

Any suggestion gratefully received.

 

[ashleedawg]

If you're importing data into Access you need to make sure that not only the destination table is closed, but also that any other db objects (queries/forms/reports/other tables) that are in any way linked to the destination table are also closed.

Try closing everything except the Visual Basic Editor window and running your import in a module.

Or, try importing the data to a new table, and then after that's successful, move the data where you need to be.

 

[CJ_London]

ensure your source file is closed