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