Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Posts
    3

    Question Unanswered: How to populate a table with a recordset

    Hi,

    I have a problem, that's why I'm posting this new message.
    I'm trying to store data from a recordset into an Access table. Actually, this recordset has the data needed because when I make a RecordCount it gives me a positive number.
    I found in an old post :
    Code:
    While Not Newrs.EOF
    Localrs.AddNew
    For i = 0 To Newrs.Fields(i).Value
    Next
    Localrs.Update
    Newrs.MoveNext
    Wend
    The recordset Newrs is already filled but I don't know how to initiate Localrs.

    Can I have a hand on this problem , please ....

  2. #2
    Join Date
    Jan 2005
    Posts
    362

    Ado

    Have tou initialise Localrs corectly (Look at the right table etc?)
    Look at http://www.w3schools.com/ado/default.asp.
    Maybe helps you
    dimis

  3. #3
    Join Date
    May 2006
    Posts
    3
    Thank you for your help !

Posting Permissions

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