Export from MSExcel to MSSQL2000

[Vipin d]

hai frndz, i want to export datafrom msexcel to a table 'stock' in the mssql2000 database. excel sheet containing "item code" and "qty" table fileds are code varchar(30) not null qty decemal(9,2) not null userid varchar(30) null dtwrk smalldatetime null i want to creat a asp.net interface to upload data from excelsheet to my database table 'stock'. is it possible? plz send any linkor some sample code.... with regards :-D All I ever wanted is what others have.... CrazySanker

[russellsoft]

In this case you can use Jet OleDb Provider or Micrisoft Excel object model... Using Jet it will be looking like the following: string ConnectionStr = String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Mode=ReadWrite;Extended Properties=EXCEL 8.0;Persist Security Info=False;", _file_path_); OleDbConnection conn = new OleDbConnection(ConnectionStr); conn.Open(); DataTable schemaTable = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] {null, null, null, "TABLE"}); foreach(DataRow drTables in schemaTable.Rows) { string TableName = drTables[2].ToString(); DataSet ds = _fill_data_set_("select * from [" + TableName + "]", conn); } in this code: file_path - full path to your Excel-file on hard disc fill_data_set - some function, which fills get DataSet then using selected from Excel-file data (which is in ds object) you insert it into your MSSQL2000 table... How to do this I think you know...