[AccessD] Add-In Express 2009 for MS Office and .NET

Hi Max et al,

Just wanted to inform that I made in principle an Export/Import add-in using
Add-In Express, and the Access.PowerTools.Add-In framework code I published
earlier today.

I have currently tested setup and export part with Access 2007, and it
worked OK.
Although there is one issue to solve tomorrow: Add-In Express's PIA for MS
Access does not have .ExportXml and .ImportXml methods for
Access.Application object - so I will have to implement it using late
binding, and note that exporting tables to XML/importing back from XML will
work only for MS Access versions 2003, 2007 and 2010. Or was Xml
Export/Import was originally introduced in MS Access XP? Then XML
export/import will also work for MS Access XP.

Thank you.

--
Shamil

-----Original Message-----
From: Shamil Salakhetdinov [mailto:shamil at smsconsulting.spb.ru] 
Sent: Sunday, February 14, 2010 8:12 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Add-In Express 2009 for MS Office and .NET

Hi Max et al,

I have made quite some C# coding to implement "EatBloat" (Export/Import)
using .NET.
Below you can find download link for the sources.
As you can find this is a set of projects, which are ready to be "plugged"
to a COM Add-In whatever way you will develop it using Add-In Express or
not. There is no any Add-In Express refs/sources there yet - so the
published stuff can be used freely.

Current status is that the export of Access db objects and data into
text/xml files, and import back/restore into a fresh MS Access db worked
well in Automation mode. Next step will be to use this coding with Add-In
Express to make Access version independent add-in.

Please ask any questions as this is a rather advanced stuff.
Please give me time to reply as I have to do other work for money in
parallel.
I'd prefer to keep this thread here as it's related to MS Access Add-In(s)
development using modern development tools to automate routine everyday MS
Access developers' work by developing different plug-ins.
As you can find the published sources were developed using mainly Test
Driven Development (TDD) approach - that allowed me to make that coding
relatively quick without any debugging sessions, and ready to be hosted in
an Access Add-in - agile practice in action...

I have got "christened" this tool as "Access.PowerTools.[Add-In]".

The stuff was developed using VS2008 SP1 on Vista Ultimate with MS Office
2007 (one project from the set is currently Access 2007 (12) dependent - it
uses Access Primary Interop Assembly v.12. There is also reference tp DAO
2.6 in the same project. The Add-In which will be developed further using
Add-In Express will not have these references/dependencies.)

Look http://northwind.codeplex.com/releases/view/26600 

for Access.PowerTools.Code.100214.zip
http://northwind.codeplex.com/releases/view/26600#DownloadId=106137 

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 4865 (20100214) __________

The message was checked by ESET NOD32 Antivirus.

http://www.esetnod32.ru