Desktop productivity for business analysts and programmers

Error when trying to export to MS Access and Excel

Reply
New Contributor
Posts: 2

Error when trying to export to MS Access and Excel

I am receiving an error "An error ocurred saving the file. Unknown" when I try to export a dataset to either MS Access or MS Excel. Any ideas?
Super Contributor
Super Contributor
Posts: 3,174

Re: Error when trying to export to MS Access and Excel

Share your SAS log information (post a reply and paste) at the point of error (and the expanded SAS code prior to the error), otherwise it will be somewhat difficult to debug with some info about your SAS program processing.

Scott Barry
SBBWorks, Inc.
New Contributor
Posts: 2

Re: Error when trying to export to MS Access and Excel

Thanks. Here is the log.

File To Export:
Table04_JoinAtrbHigh

Output File Type:
Microsoft Access File (*.mdb)

Options:
Use labels for column names : True

Output File:
C:\Documents and Settings\nbkpxp4\My Documents\Table04_JoinAtrbHigh.mdb

Total Processing Time:
5.53125 seconds

Error:
Attempt 3 : Unknown
at ADODB.RecordsetClass.AddNew(Object FieldList, Object Values)
at SAS.EG.DataAccess.DataModel.DaForJetEngineDataFiles.AddNewRecords(Object[,] a_arColValues)
at SAS.EG.DataAccess.DataModel.DataSourceManager.ExportToDataSource(String a_strTargetServer, String a_strActiveDataSource, DataSourceManager a_oTargetDSMgr, Boolean useLabelsAsColumnNames, Boolean copyIntegrityConstraints, String dateTimeFormatString)
at SAS.EG.DataAccess.DataModel.DataSourceManager.ExportToDataSource(OpenName openName, Boolean useLabelsAsColumnNames, Boolean copyIntegrityConstraints)
at SAS.EG.ProjectElements.DataExportHelper.Export(ProjectCollection project, ICanBeInputData sourceData, OpenName rawDestination, Boolean useLabelsAsColumnNames)
at SAS.EG.ProjectElements.ShortCutToData.Export(OpenName on)
at SAS.EG.ProjectElements.ExportTask.ExportRetry(IExportable iExportable, OpenName on, Int32 tryAgain)
Attempt 2 : Unknown
at ADODB.RecordsetClass.AddNew(Object FieldList, Object Values)
at SAS.EG.DataAccess.DataModel.DaForJetEngineDataFiles.AddNewRecords(Object[,] a_arColValues)
at SAS.EG.DataAccess.DataModel.DataSourceManager.ExportToDataSource(String a_strTargetServer, String a_strActiveDataSource, DataSourceManager a_oTargetDSMgr, Boolean useLabelsAsColumnNames, Boolean copyIntegrityConstraints, String dateTimeFormatString)
at SAS.EG.DataAccess.DataModel.DataSourceManager.ExportToDataSource(OpenName openName, Boolean useLabelsAsColumnNames, Boolean copyIntegrityConstraints)
at SAS.EG.ProjectElements.DataExportHelper.Export(ProjectCollection project, ICanBeInputData sourceData, OpenName rawDestination, Boolean useLabelsAsColumnNames)
at SAS.EG.ProjectElements.ShortCutToData.Export(OpenName on)
at SAS.EG.ProjectElements.ExportTask.ExportRetry(IExportable iExportable, OpenName on, Int32 tryAgain)
Attempt 1 : Unknown
at ADODB.RecordsetClass.AddNew(Object FieldList, Object Values)
at SAS.EG.DataAccess.DataModel.DaForJetEngineDataFiles.AddNewRecords(Object[,] a_arColValues)
at SAS.EG.DataAccess.DataModel.DataSourceManager.ExportToDataSource(String a_strTargetServer, String a_strActiveDataSource, DataSourceManager a_oTargetDSMgr, Boolean useLabelsAsColumnNames, Boolean copyIntegrityConstraints, String dateTimeFormatString)
at SAS.EG.DataAccess.DataModel.DataSourceManager.ExportToDataSource(OpenName openName, Boolean useLabelsAsColumnNames, Boolean copyIntegrityConstraints)
at SAS.EG.ProjectElements.DataExportHelper.Export(ProjectCollection project, ICanBeInputData sourceData, OpenName rawDestination, Boolean useLabelsAsColumnNames)
at SAS.EG.ProjectElements.ShortCutToData.Export(OpenName on)
at SAS.EG.ProjectElements.ExportTask.ExportRetry(IExportable iExportable, OpenName on, Int32 tryAgain)
Super Contributor
Super Contributor
Posts: 3,174

Re: Error when trying to export to MS Access and Excel

As Doc@Duke indicated, this is a SAS tech support issue - suggest opening a SAS support track and provide them with detailed diagnostics information.

Scott Barry
SBBWorks, Inc.
Valued Guide
Posts: 2,111

Re: Error when trying to export to MS Access and Excel

Seems like a question for tech support.
Ask a Question
Discussion stats
  • 4 replies
  • 159 views
  • 0 likes
  • 3 in conversation