Problems with .CSVData property

[Steve P.]

In an early prototype I originally used the .CSVData property with a
delimitted string which was built by the recordset.GetString method and
things worked fine. SInce then I've optimized my code and I have SQL Server
Stored procs which retrieve data and then return comma delimitted strings.
However, I cannot get my delimitted string to display in the OWC 11 SS
control. SInce I was having problems I tried some different formats and I
can't even get the simplest of strings to dosplay using the .CSVData
property. I thought all you needed was to have a typical comma delimitted
string but .CSVData seems to be picky about something. Can anyone help?
Thanks!

 

[Alvin Bruney]

It shouldn't be. Something as simple as sp.CSVDATA = "1,2\n3,4"
should load 1 and 2 on row one followed by 3 and 4 on row 2. If this doesn't
work, something else is wrong in your application.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006