Which method does not work? You may need to be more specific or quote the post you were...

OK, got somewhere on the multi-line entries.

This method may go horribly wrong if you have special characters such as ampersand, gt, lt etc since currently it's writing raw text.

Working on...

The point of this is...

Just need to get this pesky carriage return issue sorted now.

Tried the commented line but only allowed whitespace, \ n and \r there:

settings.Indent = true;

//settings.NewLineChars = "& #xA;";

See, where I will find this really handy is the following scenario...

SSRS report with multiple tables. Two summaries and a detailed list for instance.

When a user exports it to excel...

Anders Pedersen (12/4/2009)

---

Josep,

I don't have that situation here, I would just transfer the data directly from SQL to SQL. The solution should be obvious! ImportFromExcel.DLL !!! Get...

Right, I've been doing some more investigation on the issue of carriage returns.

I changed

output = dr[dc].ToString().Trim();

to

output = dr[dc].ToString().Trim().Replace(Environment.NewLine, "& #xA;");

& # (space added here to avoid displaying as a CR...

Derek.Seal (12/3/2009)

---

Great little bit of code but it still does not get me passed a very anoying problem..... which leads me to believe its my set up not the code...

Marvelous on the key thingymajig.

In addition I also have a separate Tools DB where I keep things like this, tally tables, regex CLRs etc.

Mainly that means I have a single...

Adrian Charles Chetwynd-Talbot (12/2/2009)

---

does anybody know of a full proof way of migrating data from excel to sql server using stored procedures especially where the data may contain hidden characters...

I've used similar in the past but it does not cover the fact that with this, the...

It would be really, really nice if people could actually read the previous comments and realise that 95% of the comments so far are just one liners asking for the...

1: It does say that it has been...

Calm down everyone. Source has already been asked for repeatedly. Give it time.

Thanks for opening this alternative avenue.

It looks as if it could be a bit more flexible than the...

Yeah. I'd be really worried about the security implications of this.

I thought it was a great article highlighting the problems that can arise from personally owned jobs.

Between it and the...