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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I can't specify the Specification Name when use transfertext 1
TransferText Action-tab delimited file 1
Import Excel or CSV File Using TransferSpreadsheet or TransferText 1
Error When Using TransferText in a Macro 1
Wildcard in File Name 1
Importing Text Files Into Access 1
Macro to Import TXT file and format the file 3
The text file specification '4' does not exist 0

Back
Top