I was wondering if there was a way to import records from a XML file using the import wizard. I notice that access 2007 can import records from a xml file but when I looked at the options under the SQL import wizard I did not see anything to use. I did see a SQLXMLOLEDB provider but this did not look like an options for what I was wanting to do.
Anyone doing this and maybe can shed some light on me.
Thanks