How do I import and export data from Excel and Access?
Altair EmployeeIn order to use the Excel or Access engine (in 64-bit SLC) you need to have either MS Office (64-bit) or the AccessDatabaseEngine (64-bit) installed. The main dependency is to make sure that you have installed the AccessDatabaseEngine that matches the version of SLC you have installed on your server (64 bit) (go to
http://www.microsoft.com/download/en/details.aspx?id=13255) for the download and install AccessDatabaseEngine_x64.exe for a 64-bit version.
(Make sure you select the correct connector to match your 64-bit Altair SLC installation as we no longer support 32-bit.)
Once you have the matching ACE driver then you should be able to use some proc import code of the form:
proc import datafile="demo.xlsx"
replace out = dataset
dbms=excel;
sheet="Sheet1";
Getnames = yes;
run;
See document "Altair SLC Reference for Lanuage Elements" here https://community.altair.com/community?id=kb_article&sysparm_article=KB0120333 a full list of supported options for PROC IMPORT/EXPORT.
TroubleShooting:
On a virtual machine, windows server, surface pro or modern windows OS that appears to have Office tools installed the following errors can occur:
ERROR: A database error occurred. The database specific error follows::
DATABASE error: Error occurred but unable to retrieve error data
This can be resolved by visiting above web-site and installing AccessDatabaseEngine_x64.exe for 64_bit systems.
ERROR: A database error occurred. The database specific error follows:
DATABASE error: Class not registered
typically means that there is a mis-match between Microsoft Office tools or the ACE library and the bit-ness of SLC. The bit-ness of SLC must match the bit-ness of the installed ACE library. This can be resolved by visiting above web-site and installing AccessDatabaseEngine_x64.exe for 64_bit systems.