1. 给excel降级
2.
安装Microsoft Access Database Engine 2016 Redistributable
https://www.microsoft.com/en-us/download/details.aspx?id=54920&WT.mc_id=rss_alldownloads_all
推荐安装32版本的
之后
就可以正常使用啦
image.png
3.创建的时候设置好
USE master;
GO
IF DB_ID (N'MyOptionsTest') IS NOT NULL
DROP DATABASE MyOptionsTest;
GO
CREATE DATABASE MyOptionsTest
COLLATE SQL_Latin1_General_CP1_CI_AS;
GO
网友评论