N
N
novoreg492020-10-02 11:18:53
MySQL
novoreg49, 2020-10-02 11:18:53

How to import to DB from Excel using stored function?

I have the following entities:
5f76e1d202760607693871.png
And an Excel file like this:
5f76e1ecb14b9475028841.png

How can I transfer each column of the file to the database using a database query? On the example of any of the columns.
(It is impossible to import the entire file at once, you need it with requests). Preferably in MS SQL

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Z
zexer, 2020-10-02
@zexer

https://docs.microsoft.com/en-us/sql/relational-da...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question