topic Re: Export to .mdb or .accdb error in SAS Academy for Data Science

Export to .mdb or .accdb error

BL_463_IDR — Wed, 15 Dec 2021 06:20:15 GMT

Dear All,
I want to export dataset (.bdat) to ".accdb", but the SAS System Stopped Processing the step.

i used this step to export the dataset:

PROC EXPORT DATA= ccmart.appcard_20202021_datamart
OUTTABLE= "Sheet1"
DBMS=ACCESSCS REPLACE;
DATABASE="C:\SAS_TEMP\CARD_TEMP\DATAMART_TEMP\appcard_20202021_datamart.accdb";
RUN;

when i run the export step, the system stop processing because this error below;

ERROR: CLI execute error: [Microsoft][ODBC Microsoft Access Driver] Cannot open database '|'. It may
not be a database that your application recognizes, or the file may be corrupt.
WARNING: File deletion failed for _IMEX_.Sheet1.DATA.
ERROR: Export unsuccessful. See SAS Log for details.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 7:12.00
cpu time 10.29 seconds

Note: i run this step daily, but today the error show up. (The file that succeed to export, has size > 2 gigabytes)

for further information
- SAS 9.4
- size of dataset that i want to export is 515 megabytes
- Office 365

Re: Export to .mdb or .accdb error

JosvanderVelden — Fri, 17 Dec 2021 11:18:42 GMT

I suggest to open a ticket for this: https://www.sas.com/en_us/contact/technical-support.geo.html
If you prefer to investigate before opening a ticket you can open a new sas session and save the accdb file in a different location (ex. usb stick) and attach the log-file here so we can have a closer look.

Re: Export to .mdb or .accdb error

SASKiwi — Sat, 18 Dec 2021 01:11:33 GMT

Is this a new Access database or an existing one? If it is existing then try writing to a new one in case the existing one is corrupt.

Re: Export to .mdb or .accdb error

BL_463_IDR — Sun, 19 Dec 2021 13:38:11 GMT

it was an exisiting accdb file name. I created a new accdb filename as you suggested, and it was worked, but it couldn't run for the second time coz the same error.

Re: Export to .mdb or .accdb error

JosvanderVelden — Mon, 20 Dec 2021 13:32:04 GMT

What happens if you try this with a small dataset like for instance sashelp.class?
Is the SAS PC Files Server running locally? I assume, yes.
If yes, can you verify security information? What user starts the SAS PC Files Server? What security is implemented on the folder where you write the accdb file? Does the user that start the SAS PC Files Server have Full control?

Re: Export to .mdb or .accdb error

KaueMAlmeida — Thu, 23 Dec 2021 21:49:39 GMT

It seems that you don't have access to replace the Access database.

Isn't the file being used for your SAS process? This could be a reason for your problem.

Try creating a new file and then merge with the previous file.