I have large excel file where the number of column is varied how to save it in SQl server ??? help me....!!!
I still cannot here a decent question.—SA
So, just a hint:
You can have two tables: one table represents columns, so the number of columns is variable, as you can add/remove records to/from this table. This table carry no information about the cells under the column.
Another table could represent cells, each cell referencing its column from the table of columns. One of the attributes of the cell record would be a foreign key referencing a master key of the column table.
I ignored rows because you did not ask about them. More realistically, the number of rows are also variable, some can be empty, etc.
With rows, do the same as I described with columns; you would need to add a table or rows. The each cell can reference its row having an external key referencing the master key of the row table. So, each cell references its row/column pair. This is how relational model works.
This way, 3 database table will reproduce one "jagged" spreadsheet. Additionally, you can represent a set of spreadsheets, etc.
There is a full detailed video on YouTube just search. Excel to Sql Server
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)