ansaurus

Question

sql server importing excel data with merge cells

Answer 1

A:

See this. Moreover, you can also try to export the excel file to a CSV file and then import it to SQL Server

Edit: this link may be of use: merged cells behavior

Hal 2010-09-01 08:54:17

seems like your is helpful for reporting.but i wish to import data into SQL Server.

marilyn 2010-09-01 09:11:59

OK, try exporting the table to .csv and importing it to SQL Server then. You can do it programatically (http://stackoverflow.com/questions/425379/how-to-export-data-as-csv-format-from-sql-server-using-sqlcmd) or you can use the GUI (http://msdn.microsoft.com/en-us/library/ms140052.aspx)

Hal 2010-09-01 09:27:51

or is it feasible to use rownumber(), and update cells with previous row data if it is null?

marilyn 2010-09-02 03:12:33

If you know what to put in null rows, sure.

Hal 2010-09-02 10:51:16

marilyn 2010-09-07 04:42:24

First of all, create a duplicate of that table to avoid losing data.

Hal 2010-09-07 08:37:48

Secondly, i think you'll need to use a loop to run through all the records in the table and then use a query resembling this:

Hal 2010-09-07 08:38:51

http://support.microsoft.com/kb/111401

Hal 2010-09-07 08:47:32

ansaurus

tags:

views:

answers:

sql server importing excel data with merge cells

related questions