1. Data Import Export between Different Database
/ ******* Export to Excelexec master..xp_cmdshell 'bcp settledb.dbo.shanghu out c: /temp1.xls -c -q -s "gnetdata / gnetdata" -u "sa" -p "" / *********** Import Excelselect * from OpenDataSource ('microsoft.jet.oledb.4.0', 'data source = "c: /test.xls"; user ID = admin; password =; extended Properties = Excel 5.0 ') ... xactions
/ * Dynamic file name declare @fn varchar (20), @fn = 'c: /test.xls'Set @S =' '' Microsoft.jet.Oledb.4.0 ',' ' Data Source = "' @ fn '"; user ID = admin; password =; extended Properties = Excel 5.0 '' 'set @S =' SELECT * from OpenDataSource (' @ S ') ... Sheet1
