/ *********** Import Excel Right --- Test Select * from OpenDataSource ('Microsoft.jet.OleDb.4.0', 'Data Source = "C: / Test.xls"; User ID = Admin; Password =; extended Properties = Excel 5.0 ') ... "Sheet1 $" Sheet1_
Export text file EXEC MASTER..XP_CMDSHELL 'BCP "DBNAME..TABLENAME" OUT C: /DT.TXT -C -SSERVERNAME -USA-PPASSWORD' or EXEC MASTER.. pP_CMDSHELL 'BCP "Select * from dbname..tablename" Queryout C: /dt.txt -c -ssservername -usa -ppassword '
Export to TXT text, separate the exec master..xp_cmdshell 'bcp "with comma" library name .. Table name "D: /tt.txt" -c -t, -u sa -p password'
Bulk INSERT library name .. Name from 'c: /test.txt' with (Fieldterminator = ';', rowterminator = '/ n')
