Forum Replies Created

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

  • RE: CONVERT nvarchar to numeric

    Thanks a lot.

    Your message helped me.

    May 14, 2015 at 4:39 am

    #1797787

  • RE: Inserting data from excel sheet

    pietlinden (12/9/2014)

    --Excel 2007-2010

    SELECT * --INTO #productlist

    FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',

    'Excel 12.0 Xml;HDR=YES;Database=C:\temp\Products.xlsx',

    'SELECT * FROM [ProductList$]');

    I have tried to use the query you have suggested but,...

    December 10, 2014 at 2:40 am

    #1763709

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy