Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
V
V
vbif2017-10-12 13:04:16
excel
vbif, 2017-10-12 13:04:16

How to get data from excel file without using OPENROWSET?

From time to time, excel files fall into the folder from the mail, the data from which needs to be added to the database on Sql Server. At first I tried to use the OPENROWSET statement, but from time to time, for unknown reasons, it hangs, giving no opportunity to kill the process except for restarting the sql server.

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

0 answer(s)
Similar questions
S
SMAILAIMEN2015-12-01 17:21:35
How to convert excel file need macro.? 1Reply
E
E_user2012-08-30 14:13:40
Barcode generation in Microsoft Excel? 3Reply
M
Muranx2020-05-24 01:57:18
How can I change page numbers using autocomplete? 1Reply
C
Coder 14482020-05-24 18:45:14
How in a function, when a condition is met, sum only the element located in the cell with the same number? 1Reply
F
faustflammans2018-04-21 12:43:23
WordPress ACF how to update custom field values ​​from exel file? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question