January 24, 2012 at 2:11 pm
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 ?
January 24, 2012 at 3:51 pm
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.
January 24, 2012 at 5:02 pm
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