Hi All
I am import csv file using TSQL Code
INSERT INTO [TableName]
SELECT * FROM openrowset('MSDASQL'
,'Driver={Microsoft Access Text Driver (*.txt, *.csv)}'
,'select * from \\SupermanFile.csv')
Using some env variable SQL decides how many rows to see before deciding the columns data type...
Can someone pls point me where should I look for this information?
Why bz - a few rows are null after importing... that could be bz sql column might have integers initially and later it might have text.
Thanks