Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004

    Unanswered: export to csv file

    how do i export a query to a csv file and name it . with todays date.
    example "backup 14jan06.csv" the space does not matter nor does the format of the date. there is a date field on the form i am useing caled text2. i also dont want it to run if it is not today as i will be putting it in the on open on the form event.

  2. #2
    Join Date
    Dec 2002
    Préverenges, Switzerland
    backups will sort easier if you use "backup20060114.csv"

    which part are you having difficulty with?

    the filename comes out easily enough
    dim strFileName as string
    strFileName = "c:\path\backup" & format(yourDateBox, "yyyymmdd") & ".CSV"

    also the export:
    docmd.transfertext acexportdelim, , "blahblah", strFileName

    currently using SS 2008R2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts