Excel --> Mssql have a Bulk Insert Command.. I've cut this from one of the post here, hope it helps.But Mssql --> Excel see this forum http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50191Apart from using DTS and Export wizard, we can also use this query to export data from SQL Server2000 to ExcelCreate an Excel file named testing having the headers same as that of table columns and use this queryinsert into OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=D:\testing.xls;', 'SELECT * FROM [SheetName$]') select * from SQLServerTableTo export data from Excel to new SQL Server table, select * into SQLServerTable FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=D:\testing.xls;HDR=YES', 'SELECT * FROM [Sheet1$]')To export data from Excel to existing SQL Server table, Insert into SQLServerTable Select * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=D:\testing.xls;HDR=YES', 'SELECT * FROM [SheetName$]')Exec Master..xp_cmdshell 'bcp "Select * from myTable" queryout "C:\testing.xls" -c'"If the automobile had followed the same development cycle as the computer, a Rolls-Royce would today cost $100, get a million miles per gallon, and explode once a year, killing everyone inside. "
raclede 
Excel, SQL 2000 and VB6?
Posted - 2005-06-01 : 10:46:34
I have two database (Excel and MSSQL2K) and on these databases I have different table and fields name. 
Currently my VB6 Project used two connection(ADODB) and select and insert the data row by row from MS Excel into MSSQL2K. 
I hope some body can save me into this slow setup of connection
--nightworlds--
