导入EXCEL到sql server
导入EXCEL 到Sql Server
1. 下载 Microsoft ODBC Driver 13 for SQL Server
2.
3.
Username/Password login:
4.
5.
6.
7.
8.
9.
10.
1. 下载 Microsoft ODBC Driver 13 for SQL Server
2.
3.
Driver的链接字符串
Windows login:
Driver={ODBC Driver 13 for SQL Server};server=localhost;database=your_db;trusted_connection=Yes;
Username/Password login:
Driver={ODBC Driver 13 for SQL Server};server=<server>;database=<database>;uid=<user id>;pwd=<password>;
4.
5.
6.
7.
8.
9.
10.