Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2009

    Unanswered: Dynamic table name

    I have a query that does a SELECT.. INTO tablename.

    I would like the tablename to be a fixed value plus today's date. Example: tbl_EXTRACT_070709

    You have any solution to this? - Gina Grafilo

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    strSQL = "select blah,di,blah into tbl_Extract_" & format(date(),"YYYYMMDD") will need to messa around with the formatting of the date to get the right values.

    Id suggest you use the ISO date format of year month day to create the file name, so the file will always appear in date order.

    mind you it does beg the question why anyone would want to do this, it has the faint whiff of a suspect design to me.. but its your system
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jul 2009
    Thanks a lot, I'll try that.

Posting Permissions

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