Desktop productivity for business analysts and programmers

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

Reply
Occasional Contributor
Posts: 18

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

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!

Community Manager
Posts: 2,696

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

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

Occasional Contributor
Posts: 18

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

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!

Community Manager
Posts: 2,696

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

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

Ask a Question
Discussion stats
  • 3 replies
  • 184 views
  • 0 likes
  • 2 in conversation