[thelist] importing from MySQL to Access

[Ken Schaefer]

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: From: thelist-bounces at lists.evolt.org [mailto:thelist-
: bounces at lists.evolt.org] On Behalf Of charles stuart
: Subject: [thelist] importing from MySQL to Access
: 
: I have a MySQL db that needs to be exported to MS Access.
: 
: We have our DB set up to export XML or CSV via a web 
: interface. Our older version of Access doesn't seem to 
: iport XML, but I'm wondering if the latest version of 
: Access will import XML? Microsoft's website is
: unclear to me.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

In Access 2003, there is an option for XML (.xml .xsd) in the File -> Get
External Data menu option - not sure what limitations (if any) there are on
using this. Alternatively, .csv is also available.

Cheers
Ken

--
www.adOpenStatic.com/cs/blogs/ken/