locked
how to import data from excel to sql server 2005 RRS feed

  • Question

  • User2114588165 posted

    hi all,

            how to import data from excel to sql server 2005 using asp.net 2.0 and c#

     

     Ashok

    Thursday, April 3, 2008 2:33 AM

Answers

  • User-687088760 posted
    Is this something that you going regularly. Do a data transformation, DTS from sql, into a table. and use it from there
    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, April 3, 2008 4:48 AM
  • User848370396 posted
    SELECT * FROM OPENROWSET ('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\1A.xls', 'SELECT * FROM [Sheet1$]')
    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, April 3, 2008 5:27 AM

All replies

  • User-687088760 posted
    Is this something that you going regularly. Do a data transformation, DTS from sql, into a table. and use it from there
    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, April 3, 2008 4:48 AM
  • User848370396 posted
    SELECT * FROM OPENROWSET ('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\1A.xls', 'SELECT * FROM [Sheet1$]')
    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, April 3, 2008 5:27 AM
  • User-1675332707 posted

    hi all~i have an other question here..can i apply the same method that import excel sheet in open office style which called as (open office.org calc) to sql server 2005 ??cuz microsoft excel and open office.org calc have the different format and will it make sense if i import it using same method as i import excel sheet?just curious about it..

    Thursday, April 3, 2008 5:44 AM