ODBC/Win7 64位/Excel 2010 64位是否限制为255列？
我正在使用 ODBC 写入 XLSB 文件。我是否限制为 255 列（或接近该值）？当我尝试写入 500 列时，出现以下错误：
HY001 -1040 [Microsoft][ODBC Excel Driver] Too many fields defined.
也许我的驱动程序错误？这是我的连接字符串：
"Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};Dbq=PATH_TO_XLSB_HERE;DefaultDir=OUTPUT_FOLDER_HERE;"
I'm using ODBC to write to an XLSB file. Am I limited to 255 columns (or somewhere close to that)? When I try to write 500 columns I get the following error:
HY001 -1040 [Microsoft][ODBC Excel Driver] Too many fields defined.
Perhaps I have the wrong drivers? Here's my connection string:
"Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};Dbq=PATH_TO_XLSB_HERE;DefaultDir=OUTPUT_FOLDER_HERE;"
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
Excel 2010 本身支持 16,384 列：
http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010342495.aspx?CTT=5&origin=HP005199291
您可能需要不过，要切换到 ACE.OLEDB ODBC 提供程序来利用它们。
Excel 2010 itself supports 16,384 columns:
http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010342495.aspx?CTT=5&origin=HP005199291
You probably need to switch to the ACE.OLEDB ODBC provider to take advantage of them, though.