Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO recordset XML format for globalization
I am trying to load an ADO recordset that is stored in the ADO recordset xml
format into a PivotTable. It all works fine as long as I am using English. However, the source for the ADO xml formats the data using the system's region numeric formating. For example, if I am running with the locale set to German I end up with a column value set to "12345,6" instead of "12345.6". When the ADO columns are not using English formatting, I get an error when I set PivotCache.Recordset to the ADODB.Recordset. This error occurs even on that has German set as the locale. Does the XML for the ADO recordset have to use English formatting? Is there an attribute or something we could add to the xml identifying the locale that was used to generate the XML? If we always use English formatting for the ADO recordset XML would it work for all locales including Japanese? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need ADO Recordset Help | Excel Programming | |||
Type recordset/recordset? | Excel Programming | |||
Recordset | Excel Programming | |||
Looping Through A Recordset | Excel Programming | |||
Looping Through A Recordset | Excel Programming |