且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

当文件名太长时,如何使用oledb reader读取.csv文件?

更新时间:2022-03-04 09:23:08

根据我的测试,看来OLEDB的文件名受到限制最多为64个字符,其中包括.csv扩展名.
According to my tests, it would appear that a filename for OLEDB is restricted to a total of 64 characters, this includes the .csv extension.


首先检查文件名,如果文件名太长,可以暂时将其更改为较短的文件名(如果文件名不是太短)较大的文件,您可能需要一个临时副本),然后将其转换回(或删除该临时文件).
first check the filename, if it is too long you could temporarily change it to something shorter (if the file is not too large you might want a temporary copy) and then convert it back (or delete the temporary file).