Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    330
    Thanks
    10
    Thanked 0 Times in 0 Posts

    Writing a CurrentDb.Execute

    Can I write a CurrentDb.Execute to append all of 1 table to another?

    Contents of small temp table to std table after checking data is correct.
    "Heading for the deep end"

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Yes you can, or you can just run a standard query.

    Initially create an append query using the query designer, convert to SQL view and copy the SQL.

    Then in your event procedure either
    Docmd.openquery "qryYour appendquery"

    or
    Dim SQL as string
    SQL= "your copied SQL'
    Currentdb.execute SQL
    Regards
    John



  3. The Following User Says Thank You to johnhutchison For This Useful Post:

    weyrman (2011-05-25)

Posting Permissions

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