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 |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2004-06-22 : 11:06:08
|
Sung to the tune of "Where have all the cowboys gone?"  I've got an EXCEL spreadsheet, the last 4 columns have headers, but no data.When I save it as a CSV file, EXCEL correctly includes the trailing commas on the first 14 lines of CSV, then doesn't include the trailing commas on the rest of the data.DTS isn't going to like this at all. Is anyone familiar with this problem ? Any workaround?Sam |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-06-22 : 13:31:58
|
| Wild guess: Are the rogue cells in some way NULL rather than Empty? I don't know, but can you put =""in them?Kristen |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-06-22 : 14:04:40
|
| Thanks for the suggestion, it works great.Now is there an EXCEL trick to paste a cell value of "" into all rows of the last column (there are 35000 rows)? I can select the entire column, but that results in pasting into additional rows beyond the rows that have data.Sam |
|
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2004-06-22 : 15:10:39
|
| 1) go to column that you want to fill2) hold shift and arrow to a column that is filled to 350003) still holding shift: hit ctrl-dwn (dwn: down arrow)4) still holding shift: arrow back to correct column5) ctrl-v to fillCorey |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-06-22 : 15:11:40
|
| Thanks Corey (and Kristen)Sam |
|
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2004-06-22 : 15:13:10
|
| read the edit...i messed up the first timeCorey |
|
|
|
|
|
|
Where have all the commas gone?