excel to sql

[cj]

I've been asked to take thousands of excel files and import them into a
sql database. What's the best way to accomplish this? All the excel
files have the same structure and I can create a sql table with the same
structure. The excel files do have a header record. There are
approximately 30 fields/columns of varying types including dates and
boolean. approximately 50 records/rows per file.

[Cor Ligthert[MVP]]

Re: excel to sql

cj,


For the best approach I would look what SQL tools there are available to
import. I surely would do this one time with a Net program.

If it is about one type of excel sheet, that has to be thousand times
imported in one SQL table, then I would look what OleDb could do for me.

As you look at the sample here you have almost everything

https://www.connectionstrings.com

Cor