Results 1 to 3 of 3

Thread: access

  1. #1
    Join Date
    Dec 1969

    Default access

    Greetings all,<BR> I have two tables is Access; I simply want to transfer one column of data in Table_A to Table_B. I&#039;ve tried running update queries but just can&#039;t seem to work.<BR><BR>thanks in advance.<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: access

    Are you needing to do this with ASP or is doing it inside of MS Access OK?<BR><BR>

  3. #3
    Join Date
    Dec 1969

    Default If in Access then...

    First, create the column in the destination table (you can do this manually or programatically easily enough).<BR><BR>Then (Assuming you have a common key) run a statment similar to this:<BR><BR>UPDATE tbl_A INNER JOIN tbl_B ON tbl_A.ID = tbl_B.Id SET tbl_B.NewColumn = [tbl_A].[OldColumn]<BR><BR><BR>You can do the same thing in ASP if you want OR you can open a recordset, loop through it, blah, blah....

Posting Permissions

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