Post reply

How to Import data from Excel to Table and Export data table to excel

  • April 6, 2010 at 3:28 am

    #1146367

    The same error which earlier i described is coming.....

    Big hectic for me...

  • April 6, 2010 at 4:02 am

    #1146376

    chandrasekaran.ganapathy (4/6/2010)

    SELECT * INTO XLImport4 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

    'Excel 8.0;Database=C:\test\xltest.xls', [Customers$])

    Hi Here Customers$ refers the table name?

    try with OPENDATASOURCE

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • April 6, 2010 at 10:13 pm

    #1146995

    Insert into Table1

    SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',

    'Data Source=C:\test\testing.xls;Extended Properties=Excel 8.0')...[sheet1$]

    finally this code is working..

    Thanks bhuvanesh......

Viewing 3 posts - 16 through 17 (of 17 total)

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