SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Unable to export using export wizard or proc export

Reply
N/A
Posts: 0

Unable to export using export wizard or proc export

We do a lot of exporting of SAS datasets to Excel and Access. Suddenly, 2 of us in the office are getting:

ERROR: Connect: 
ERROR: Error in the LIBNAME statement.

messages when we try to export. Both the export wizard and proc export generate the errors. And the Libname is correct because just last week I was able to export a file from the same lib.

When my colleague had the problem it was on a new PC so I simply deleted her profile and when she logged in and recreated her profile she was able to export. But only for a week or so then the problem returned.

We're all running v9.1.3 on XP with the latest patches/SP.

Any ideas how to fix this?

Thanks
SAS Super FREQ
Posts: 8,814

Re: Unable to export using export wizard or proc export

Hi:
Could you be getting either of these errors:

ERROR: Connect: The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data.
ERROR: Error in the LIBNAME statement.

ERROR: Connect: Unable to IDBInitialize
ERROR: Error in the LIBNAME statement.

as described on page 11 of this paper:
http://www2.sas.com/proceedings/forum2007/119-2007.pdf

These Tech Support notes also mention the exact text of your error message:
http://support.sas.com/kb/12/784.html
http://support.sas.com/kb/3/588.html
http://support.sas.com/kb/6/067.html
http://support.sas.com/kb/14/851.html


For the most thorough help, you might consider contacting Tech Support so they can help you figure out exactly what the cause of your problem is.

cynthia
Ask a Question
Discussion stats
  • 1 reply
  • 186 views
  • 0 likes
  • 2 in conversation