Shamil Salakhetdinov
shamil at smsconsulting.spb.ru
Mon Feb 15 03:32:05 CST 2010
Hi Max, William, whoever else who follows this thread et al,
I'm wrapping Add-In setup and I'm testing it here - so far so good - almost
all works fine - I have just found one issue:
- .ImportXml does create tables structure OK but doesn't import data nor
when used in C# Automation mode, nor when running within COM-Add-In. I have
tried both .ImportXMl options - structure and data or append data...
Is it a known bug/feature? (when running .ImportXml of the same file from
within VBA it works OK).
I'm currently using MS Access 2007.
Thank you.
--
Shamil
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Sunday, February 14, 2010 1:32 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Add-In Express 2009 for MS Office and .NET - Create a
NEW DB and populate with objects.
Thanks Shamil,
I look forward to your development.
In your code, you missed the TARGET folder from this code:
app.ExportXML acTable, _
rst![ObjectName].Value, _
strTargetFileName + ".xml", _
strTargetFileName + "Schema.xml"
should it be:
app.ExportXML acTable, _
rst![ObjectName].Value, _
strTarget + strTargetFileName + ".xml", _
strTarget + strTargetFileName + "Schema.xml"
Max
<<< snip >>>
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4866 (20100214) __________
The message was checked by ESET NOD32 Antivirus.
http://www.esetnod32.ru