Is there a way to create an ACEXML using EG 4.3 ?

[GregINGov]

Is there a way to create an ACEXML file using EG 4.3? I am not finding one if there is am I over looking a way to do this?

Thanks!

[ChrisHemedinger]

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:

Export to Excel 2007/2010 using SAS Enterprise Guide - The SAS Dummy

Chris

[GregINGov]

Chris,

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!

[ChrisHemedinger]

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).

Chris