Post reply

what's the best way to migrate formatted excel data to sql server

  • August 9, 2018 at 2:33 pm

    #375680

    what's the best way to migrate formatted excel data to sql server

  • August 10, 2018 at 1:43 am

    #2001163

    You could use the import wizard which is pretty straightforward to use. In SSMS right click on the database --> Tasks --> Import Data and select Excel.
    You could also use SSIS which is probably the best way to go if you regularly need to import the data.

    Thanks

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

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