updating all data form one table to another

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • steve
    #1

    updating all data form one table to another

    Hello, I am trying to take all the data from one table and transfer it
    to another table with exactly the same column names in the same
    database. I have done this with a small sql script in an update query
    but now can't seem to figure out how. =(
    I am doing this because one of the tables is a linked table to a mysql
    table and I am copying the data then deleting the original table which
    is in access 2000.
    Thanks for any help
    steve
    Tags: None
    • Tom van Stiphout
      #2
      Re: updating all data form one table to another

      On 21 Apr 2004 19:52:12 -0700, stephen_spencer @yahoo.com (steve)
      wrote:

      Try this:
      insert into NewTable
      select * from OldTable

      -Tom.

      [color=blue]
      >Hello, I am trying to take all the data from one table and transfer it
      >to another table with exactly the same column names in the same
      >database. I have done this with a small sql script in an update query
      >but now can't seem to figure out how. =(
      >I am doing this because one of the tables is a linked table to a mysql
      >table and I am copying the data then deleting the original table which
      >is in access 2000.
      >Thanks for any help
      >steve[/color]

        Comment

        • Ray
          #3
          Re: updating all data form one table to another

          stephen_spencer @yahoo.com (steve) wrote in message news:<4992bbe3. 0404211852.2b9c fef@posting.goo gle.com>...[color=blue]
          > Hello, I am trying to take all the data from one table and transfer it
          > to another table with exactly the same column names in the same
          > database. I have done this with a small sql script in an update query
          > but now can't seem to figure out how. =(
          > I am doing this because one of the tables is a linked table to a mysql
          > table and I am copying the data then deleting the original table which
          > is in access 2000.
          > Thanks for any help
          > steve[/color]

          Hello Steve,

          Perhaps you could use a "Make Table" query.

          Ray

            Comment

            • Eric Ellsworth
              #4
              Re: updating all data form one table to another

              Hi Steve,
              Note that if the MySQL table does not already exist, you will need to
              create it, either using a pass-thru query, or some other tool to work in
              MySQL. Once that's done you can use the INSERT statement posted above.

              Cheers,

              Eric

              steve wrote:
              [color=blue]
              > Hello, I am trying to take all the data from one table and transfer it
              > to another table with exactly the same column names in the same
              > database. I have done this with a small sql script in an update query
              > but now can't seem to figure out how. =(
              > I am doing this because one of the tables is a linked table to a mysql
              > table and I am copying the data then deleting the original table which
              > is in access 2000.
              > Thanks for any help
              > steve[/color]

                Comment

                Previous template Next
                Working...