Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    29

    Unanswered: Writting records from one table to another

    I'm trying to write data from one table to another. First I have to do some question on the data to determine what I need to do with the records. But what I want to do, is write one row at a time to a different table.

    I currently have it written to do field at a time. But I don't know what the field names are going to be, because this is from an import and the field names could be different. But the data will be the same for each table.

    Any suggestions will be helpful.

    Thanks,

  2. #2
    Join Date
    Oct 2003
    Posts
    29

    Sorry

    My connectivity went down in the middle of my posting. and I didn't think it posted.

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    You can't make a static function for non-static tables. You might get away with pulling everything into datasets and using indexes. This is assuming that the "import" table is always of the EXACT same layout and structure.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  4. #4
    Join Date
    Oct 2003
    Posts
    29

    Table

    The tables that I'm copying from and to will have the exact say layout.

Posting Permissions

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