import data from excel to sql server

I want to use oledb to obtain an excel file locally as a data source. The program runs well locally on the server. once it reaches the remote end, an error occurs. The following error is prompted: 'F: \ import Excel file \ data

Excel 1. query Excel Data in SQL Server: -- ===================================================== ==================== Select * From OpenDataSource ('Microsoft. Jet. oledb.4.0 ', 'Data source = "C:/book1.xls"; user id = admin; P

// Filename: absolute path of the Excel file Private dataset readexcel2 (string filename){If (filename. Trim (). Length = 0){Return NULL;} If (! System. Io. file. exists (filename )){Return NULL;}String strconn = "provider = Microsoft. Jet. oledb.4.0 ;"+ "Data Source =" + filename + ";"+ "Extended properties = Excel 8.0 ;"; Oledbconnection objconn = new oledbconn

--office 2003--If the table that accepts the data import already existsINSERT INTO demotable SELECT * FROMOPENROWSET (' MICROSOFT. JET. oledb.4.0 ', ' Excel 5.0; Hdr=yes;database=d:/demo.xls ', sheet1$)--If you import data and generate a tableSELECT * Into demotable from OPE

Import data from Excel into database via access1. Open access, click "EXTERNAL DATA", select Upload "Excel", select the Excel you want to import, click OK.2. Select the sheet to upload

whether the file exists.{Strconn = "provider = Microsoft. jet. oledb.4.0; Data Source = "+ path +"; extended properties = 'excel 8.0; HDR = yes; IMEX = 1'; "; // IMEX = 1 to convert textOledbconnection conn = new oledbconnection (strconn );Oledbdataadapter mycommand = new oledbdataadapter ("select * from [sheet1 $]", strconn );Dataset mydataset = new dataset ();Mycommand. Fill (mydataset, "[sheet1 $]");For

Dim Conn, connstr Connstr = "driver = {SQL Server}; uid = sa; Pwd = *****; database = tushu; server = sql2005" Set conn = server. Createobject ("ADODB. Connection ") Conn. Open connstr'Here is excel2007. Use 'Microsoft. Ace. oledb.12.0 '. For example, 97-2003, use 'Microsoft. Jet. oledb.4.0'

// Test. Import Sheet 1 in Excel to private void run_click (Object sender, eventargs e) {system. windows. forms. openfiledialog FD = new openfiledialog (); If (FD. showdialog () = dialogresult. OK) {dataset DS = transferdata (FD. filename, "sheet1"); addbatch (Ds. tables [0]) ;}} public dataset transferdata (string excelfile, string sheetname) {dataset DS = new dataset (); try {// obtain all

('Microsoft. Jet. OLEDB.4.0 ', 'Data Source = "c: DB. mdb"; User ID = Admin; Password = ')... table name (Column name 1, column name 2) Select column name 1, column name 2 from SQL table Instance: Insert into OPENROWSET ('Microsoft. Jet. OLEDB.4.0 ', 'C: db. mdb '; 'admin';', Test) Select id, name from Test Insert into openrowset ('Microsoft. Jet. OLEDB.4.0 ', 'c: rade. mdb'; 'admin'; ', table name) SELEC

database more complex tasks, in excle and other tools can be easily completed. When the contents of the table are modified correctly, the database administrator can import the files from the Excle table directly into the SQL Server database. Because SQL Server is born with

source to SQL commands, and then enter the query statement: Select * from production. productwhere (color ='Black') When you execute the statement again, you will find that the generated Excel table only contains color = 'black' data (Note: If the Excel files of all your data