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

    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
    Location
    Préverenges, Switzerland
    Posts
    3,740
    observation:
    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

    izy
    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
  •