Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2007
    Posts
    48

    Unanswered: Transferring data between Access tables using VBA

    I would like to take three fields from one table, and append them to three fields in another table. In this case, the field names may differ.

    Can anyone oplease advise VBA coding to go about this?

    All suggestions and pointers gratefully received

    many thanks,
    Jill ( an Access newby)

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    It would be simplest to create an append query to do it. If you want to use VBA, you'd have to open recordsets on each table, and use the values from one to add to the other.
    Paul

  3. #3
    Join Date
    Dec 2007
    Posts
    48

    Thanks

    Many thanks Paul. Sounds good.

    can you please advise generalised code statement to run a Query from VBA?

    with thanks,

    Jill

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    CurrentDb.Execute

    or

    DoCmd.RunSQL
    Paul

  5. #5
    Join Date
    Dec 2007
    Posts
    48
    Thanks Paul. Found the exact one I was after:

    DoCmd.OpenQuery "qryAppend_Av_Temps"

Posting Permissions

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