Error when trying to export to MS Access and Excel

[Mark_C]

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?

[sbb]

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.

[Mark_C]

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)

[sbb]

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.

[Doc_Duke]

Seems like a question for tech support.