Post reply

SQL server 2012 - format change functionality

  • May 30, 2017 at 1:59 am

    #343029

    I need to bulk insert an Excel file into my Sql server 2012 DB.
    Since I can be only able to bulk insert an CSV file, Is there any possibilities to convert the Excel file into CSV file beforehand and then bulk insert in into DB?
    Or is there any other way to do it?
    How to implement this case?

    Note--
    I need to automate this process completely. All this needs to be done on pressing F5, there shouldn't be any manual work involved.

  • May 30, 2017 at 2:07 am

    #1944528

    divyashreenivasan - Tuesday, May 30, 2017 1:59 AM

    I need to bulk insert an Excel file into my Sql server 2012 DB.
    Since I can be only able to bulk insert an CSV file, Is there any possibilities to convert the Excel file into CSV file beforehand and then bulk insert in into DB?
    Or is there any other way to do it?
    How to implement this case?

    Note--
    I need to automate this process completely. All this needs to be done on pressing F5, there shouldn't be any manual work involved.

    Which Excel file format (BIFF) will you be using?
    Why can you only use CSV? 
    😎

  • May 30, 2017 at 2:11 am

    #1944529

    Are you using the Import and Export wizard to do this? If so you can import from Excel or you can create your own SSIS package to do the import and then set up a job to run the package.

    Thanks

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

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