Import File Path - How do I change the code

[mtexplorer]

I am using the following

DoCmd.TransferText acImportDelim, "Specification", "Table", "C:\file.csv", No

And this works fine but I would like to have the user type in the path and have the code reference that field instead of the "C:\file.csv" that is in the code above.

I have tried a few items in place of it but it does not seem to be the correct syntax or the correct way to do it. Is there an easy way to accomplish this?

Thanks for any help.

[Darren McDonald]

attached file demonstrates allowing user to pick the file they want to import.

Cheers
darren

[NeoPa]

I'm not really clear where your confusion lies. This is a simple case of replacing the literal text ("C:\file.csv") with a reference to the variable or control used.

Assume a form with a TextBox control, called txtFile, to allow the operator to enter the address of the file. Your code would be something like :

Call DoCmd.TransferText(acImportDelim, "Specification", "Table", Me.txtFile, False)