TransferText File Selection

[Guest]

I am using an Access Macro to transfer text files to may database.

Using the TransferText Command

I want to enter the name of the file to be transferred.

I have tried the script of:

C:\FirstNM\Forms![frmImportB]![TextA]

in the Argument Column.

I input the name of the file in TextA on a form called frmImportB.

Can this be done and does anyone know the correct syntax if it can be done.

Thanks in Advance

Len

 

[Steve Schapel]

Len,

Not 100% sure, but try it like this...
="C:\FirstNM\" & [Forms]![frmImportB]![TextA] & ".txt"

Let us know.