MS Access with extension 'accde' import into SAS

[ismahero2]

Hi,

I have an MS Access file named  "DataToOpen.accde" that I need to import into SAS.  In it it has a table named "tblActionTaken".   When I try the proc import procedure using DBMS=ACCESS it tells me: 'invalid or missing file extension for this engine'.   I tried with Excel but it doesn't work.  Anyone has a program I can use to import the data into SAS or an idea on how to do it?

[ballardw]

I only find refernce to ACCDB files, not ACCDE extensions.  Can you use Access to create an ACCDB format file from that ACCDE?

I haven't used Access for about 10 years so don't remember what an Accde file might have been for that isn't in an Accdb.

[Tom]

A search found a reference to that format to one where the VB code has been compiled rather than stored.  Perhaps it was done for some desire to hide the code?

At this point your best option is to use Access (or some other Microsoft tool) that can read the file and convert it to something that SAS can read.  Perhaps you can save it back as a normal Access file.  But perhaps you will have to safe the individual tables as separate files, perhaps as XLSX worksheets.