Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
chulz90
Starting Member
26 Posts |
Posted - 2013-04-29 : 22:06:24
|
hello..i've some problem, i want to insert data from excel file which is contain more 8000 rows in excel.in 1 row sometimes there's 1 or 3 that an empty cell.can you help me to solve this ??? |
|
MuMu88
Aged Yak Warrior
549 Posts |
Posted - 2013-04-30 : 00:47:57
|
Export data from Excel as csv file, use BULK INSERT .As long as your database table accepts NULL values you should be able to insert the data. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-30 : 04:12:18
|
Sorry didnt get the actual issuewhat happens when you try to insert? is it putting wrong values or throwing some error?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|