Question Retrieve data from variable directory

[Jean-Didier]

Hello

I need your help

It is possible to retrieve files from variable directory to append data in a table ?

Ex : i need my access to retrive files from \\srv64\Shared\backoffice_dts_extraction\archive\23032010

\23032010 is date of the automatix extractions from another software. Each day a new directory is made and files put in

there are several files (more than 125) in this directory and i need only 4 files
This files are same as the variable directory.. they begin with variable date

Ex : 23032010_sp_dts_day_sorting_list_24.csv

Is it possible to make something to help me ?
Thank you for advance and sorry for my bad english

 

[namliam]

Something like so will do your trick for you.

YourFile = "\\srv64\Shared\backoffice_dts_extraction\archive\" & Format(date, "DDMMYYYY") & "\"&Format(date, "DDMMYYYY") & "_sp_dts_day_sorting_list_24.csv"

 

[Jean-Didier]

Thank you, but, how use it ?, in a query ?

 

[namliam]

what do you want to do? Import, so you have an import procedure someplace?
Thats where you use it... ie. Docmd.transfertext command