Post reply

Append problem

  • October 1, 2006 at 6:25 pm

    #172912

    Hi Guys.

    I have got few tables in my database in sql which I exported from ms access. Now these tables have been updated in access and I need to have the updated copies of these tables in SQL.

    Is there a work around for that.

    What I Do is I delete all my existing tables and re - import the updated tables?

    Is there a simpler way may be through stored procedures or something??

  • October 2, 2006 at 6:38 am

    #663560

    It might be easier to delete the existing tables and re-import unless each row is uniquely identified. If the latter is the case, then I would import the tables into another name and run an UPDATE and INSERT command.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply