IT博客汇 | sql读取csv和xls格式的文件,数据源-CarlZeng

sql读取csv和xls格式的文件,数据源-CarlZeng

Carl Notes发表于 2023-10-02 02:27:29

csv： select * from OpenRowset('MSDASQL','Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=d:\;Extended properties=''ColNameHeader=True;Format=CSVDelimited;''','select * from sheet1.csv') 用系统...