12-05-2012 02:50 PM
I don't know what ACEXML is, and a quick Google search didn't help me. If you mean, perhaps, an Excel 2007/2010 file (xlsx) which is supported by the Microsoft ACE API (and is XML-based under the covers), there is this custom task:
12-05-2012 03:07 PM
See I knew that microsoft access should be able to do it but did not realize that xlsx was also ACE XML BASE....
But I believe you have the meaning of what I mean by ACE XML.
Thanks so much!
12-05-2012 03:17 PM
ACE is the Microsoft replacement for Jet, the name of the built-in data access engine in Microsoft Windows.
ACE is used for the Office 2007/2010 formats for XLSX (Excel) and ACCDB (Microsoft Access). The custom task I mentioned supports only Excel.
For Access, you can export MDB files (the older format). Or you can use SAS/ACCESS to PC Files or ODBC to write SAS programs that update Microsoft Access databases (new or old format).