topic MS Access with extension 'accde' import into SAS in SAS Programming

MS Access with extension 'accde' import into SAS

ismahero2 — Wed, 28 Jun 2023 14:09:26 GMT

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?

Re: MS Access with extension 'accde' import into SAS

ballardw — Wed, 28 Jun 2023 15:00:32 GMT

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.

Re: MS Access with extension 'accde' import into SAS

Tom — Wed, 28 Jun 2023 16:13:41 GMT

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.