测试:
Script:
create table #Test ( Name nvarchar(10), Age int, T nvarchar(10) ) BULK INSERT #Test From 'I:\AAA.csv' with( fieldterminator = ',', rowterminator = '\n' ) select * from #Test drop table #Test
Result:
Name Age T
TestA 13 Aug
TestB 14 App
TestC 15 Jus