Data Transfer Issue

  • Hi,

    i am trying to migrate some data from MS Access to SQL server Database. The tables already exist in the sql database but when i try to import data from MS Access table to SQL table i get an error message that table already exist and when i try to change the setting into Import/Export wizard i notice that Append data option is disabled.. please help ?

  • This may or may not be of help to you, but it is the only method I have utilized and it worked for myself. So for what assistance it might be to you try following the instructions at:

    http://msdn.microsoft.com/en-us/library/ms140052(v=sql.100).aspx

    Sorry I could not be of more assistance.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Thank you for your reply. I tried all of the things mentioned in the doc already but for some reason that Append query option is not enabled for me.

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

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