topic Re: Is there a way to create an ACEXML using EG 4.3 ? in SAS Enterprise Guide

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

GregINGov — Wed, 05 Dec 2012 19:45:55 GMT

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!

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

ChrisHemedinger — Wed, 05 Dec 2012 19:50:56 GMT

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

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

GregINGov — Wed, 05 Dec 2012 20:07:39 GMT

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!

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

ChrisHemedinger — Wed, 05 Dec 2012 20:17:20 GMT

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