How do I use Date Functions for File Names in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create an OutPutTo Excel file using a date function to name
the output file. Basically I need to be able to name the output file using
the current date and time or use the current date with an incrementing number
for each file generated for that date.
 
Use an expression similar to this in the argument for the filename:

="C:\MyFolder\FileName" & Format(Date(), "mmddyyyy") & ".xls"
 

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

Output File Naming 8
In OutputTo, How can I name file using current date 4
Current date in file name 1
Can output file name from access query-create table include date . 1
Remove prompt for replacing file 5
Export table to txt file with a variable filename 0
IPhone sound quality gets worse each generation 5
Naming files automatically 1

Back
Top