Post reply

T-sql 2012 with uniqueidentifier issue

  • December 28, 2015 at 10:54 am

    #399509

    I copied some test data to an excel spreadsheet 2013 as a backup. Now I need to load the test backup data to sql server 2012. I want to use the import wizard to import this data. The problem is one of the columns is a uniqueidentifier that is set to not null. I am trying to load the data but I am having a problem. Thus can you tell me and/or point me to a reference that will tell me how to load the data and get past the error I am having?

  • December 28, 2015 at 10:59 am

    #1848315

    What's the error/problem that you're having?

    Are you assigning the correct data types in the wizard?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • December 28, 2015 at 12:15 pm

    #1848328

    what date type should I assign in the wizard?

  • December 28, 2015 at 9:50 pm

    #1848392

    wendy elizabeth (12/28/2015)

    what date type should I assign in the wizard?

    I don't think it has anything to do with dates. I don't remember if you get a uniqueidentifier data type (I don't use them) in the Import/Export wizard, but that's the right one to use.

    Better yet, if you don't need the data yet, then try creating a backup in a SQL Server table instead of an Excel spreadsheet. Then all you'll have to do to recover is insert the data from your backup into your table right from SQL Server without having to get Excel involved at all.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

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

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