Transfert Text File Name

  • Thread starter Thread starter kidzmom3
  • Start date Start date
K

kidzmom3

I have a macro that uses the TransferText action to import
at tab delimited file, and it works great, but I want to
have the File Name reference to a field in a table to get
the UNC path. This way the user(s) in each office can
customize the network path for the import without editing
the macro.
 
Use an expression similar to this as the "File Name" argument:

=DLookup("FileNameFieldName", "TableName", "[PKeyField]=" & "SomeValue")
 
Worked like a charm!! Thanks a bunch!!!
-----Original Message-----
Use an expression similar to this as the "File Name" argument:

=DLookup("FileNameFieldName", "TableName", "[PKeyField]=" & "SomeValue")

--
Ken Snell
<MS ACCESS MVP>

kidzmom3 said:
I have a macro that uses the TransferText action to import
at tab delimited file, and it works great, but I want to
have the File Name reference to a field in a table to get
the UNC path. This way the user(s) in each office can
customize the network path for the import without editing
the macro.
Click to expand...


.
Click to expand...
 
Back
Top