Excel导入SQLserver报错,本人小白刚开始研究SQL,请大神帮忙解惑
回答
收藏

Excel导入SQLserver报错,本人小白刚开始研究SQL,请大神帮忙解惑

限量版613
2023-10-30 17:09·浏览量:702
限量版613
影刀高级开发者
发布于 2023-10-30 17:03更新于 2023-10-30 17:09702浏览

(102, b"Incorrect syntax near '\xb7'.DB-Lib error message 20018, severity 15:\nGeneral SQL Server error: Check messages from the SQL Server\n")

Traceback (most recent call last):

 File "C:\Program Files\ShadowBot\shadowbot-5.13.33\python\lib\runpy.py", line 193, in _run_module_as_main

   "__main__", mod_spec)

 File "C:\Program Files\ShadowBot\shadowbot-5.13.33\python\lib\runpy.py", line 85, in _run_code

   exec(code, run_globals)

 File "C:\Program Files\ShadowBot\shadowbot-5.13.33\python\lib\site-packages\xbot_interpreter.py", line 94, in <module>

   main()

 File "C:\Program Files\ShadowBot\shadowbot-5.13.33\python\lib\site-packages\xbot_interpreter.py", line 53, in main

   try:

 File "C:\Users\admin\AppData\Local\ShadowBot\users\101568661188304897\apps\6a544e74-f50e-4417-ad43-0e39f37620cf\xbot_robot\main.py", line 22, in main

   ], _block=("main", 3, "SQL Server 批量导入数据"))

 File "<string>", line 89, in wrapper

 File "<string>", line 84, in wrapper

 File "<string>", line 82, in run

 File "C:\Users\admin\AppData\Local\ShadowBot\users\101568661188304897\apps\6a544e74-f50e-4417-ad43-0e39f37620cf\xbot_extensions\activity_759a3f99\process4.py", line 39, in main

   }, _block=("SQL Server 批量导入数据", 1, "调用模块"))

 File "<string>", line 89, in wrapper

 File "<string>", line 84, in wrapper

 File "<string>", line 37, in invoke_module

 File "C:\Users\admin\AppData\Local\ShadowBot\users\101568661188304897\apps\6a544e74-f50e-4417-ad43-0e39f37620cf\xbot_extensions\activity_759a3f99\SQL_Server_functions.py", line 92, in bulk_copy_for_SQL_Server

   raise ValueError(error)

ValueError: (102, b"Incorrect syntax near '\xb7'.DB-Lib error message 20018, severity 15:\nGeneral SQL Server error: Check messages from the SQL Server\n")


收藏
全部回答1
最新
发布回答
回答