Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello, I am using Excel XP with Win 2000 and ADO 2.5.
1) When converting an ADO recordset into a string using "GetString", does anyone know of any bugs, row limitations, length or size restrictions, etc. with this method? I'm considering using this method for importing data when there is too much to fit into an Excel sheet. Alternatively, I will port the data into a CSV text file and I just wanted to know how stable this method is. I would use the syntax shown below: rsADO.GetString(adClipString, , ",", vbCr) 2) Also, does anyone know if this method automatically (internally) surrounds each column with double quotation marks? If not how can I get it to do this? Please illustrate the syntax. Thanks much in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |