The solution of SSMS importing Excel data prompt without installing plug-in

Time:2021-4-8

Today, when importing excel with SSMS, the prompt
Then I found a solution and installed the corresponding plug-in. But it will still prompt this question.
Another reason is that SQL server is 32-bit when it is started, but the import needs 64 bit. However, if SSMS is started, it can only be 32-bit. If you want to start 64 bit, you need to install SQL server.
I didn’t install it because I was in a hurry. I copied it to a text file and then imported it for reference only.

Recommended Today

asp.net Application of regular expression

1. Balanced group / recursive matching (?’ Group ‘), which is called the corresponding content of group, and counts it on the stack;(?’- Group ‘), and count the corresponding content named group out of the stack(?!) Zero width negative look ahead assertion. Since there is no suffix expression, attempts to match always failRegular example:,{0,1}”5″:\[[^\[\]]*(((?’Open’\[)[^\[\]]*)+((?’-Open’\])[^\[\]]*)+)*(?(Open)(?!))\],{0,1} Test […]