Ac2002: ImportXML method with XSLT?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

Using Ac2002 with VBA, I encountered a problem with the Application object's
ImportXML() method:

This method is specified in the Access documentation ("Visual Basic Help")
with the following signature:

Sub ImportXML(DataSource As String, DataTransform As String, OtherFlags As
Long)

However, the object browser (and thus in the type definition) specifies:

Sub ImportXML(ByRef DataSource As String, Optional ByRef ImportOptions As
AcImportXMLOption = acStructureAndData)

I clearly can only use the typedefed variant, i.e. the latter.

Since I have to transform the XML (replace decimal points by German "decimal
commas", which is what Access in a German Windows environment expects), I'd
be grateful if any of you told me how to use ImportXML() with XSLT.

I could, of course, first transform the original file into a modified one,
and then import this. But it would be much easier, if Access really supported
stylesheet transformation as the help pages seem to promise.

Thanks in advance for any hints!

JotKa
 
Since I have to transform the XML (replace decimal points by German "decimal
commas", which is what Access in a German Windows environment expects), I'd
be grateful if any of you told me how to use ImportXML() with XSLT.
Click to expand...

Even though I am still interested if the XSLT option is available with the
ImportXML command, transforming the XML data has proven not to solve the
problem: After having replaced the decimal points by commas, Access
complained about an invalid number format; I obviously have to import numbers
using a decimal _point_.

The problem is not yet solved; please see the next post for it.

JotKa
 
I've never had much problem with this I think that you should give us more
info

for the record, SQL Server 2005 has a LOT better XML functionality

there is a real XML datatype and I love SQL 2005
 
Back
Top