https://communities.sas.com/t5/SAS-Enterprise-Guide/Error-when-trying-to-export-to-MS-Access-and-Excel/m-p/59863#M6089 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.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Wed, 29 Jul 2009 16:42:23 GMT sbb 2009-07-29T16:42:23Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Error-when-trying-to-export-to-MS-Access-and-Excel/m-p/59862#M6088 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? Wed, 29 Jul 2009 14:52:55 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Error-when-trying-to-export-to-MS-Access-and-Excel/m-p/59862#M6088 Mark_C 2009-07-29T14:52:55Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Error-when-trying-to-export-to-MS-Access-and-Excel/m-p/59863#M6089 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.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Wed, 29 Jul 2009 16:42:23 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Error-when-trying-to-export-to-MS-Access-and-Excel/m-p/59863#M6089 sbb 2009-07-29T16:42:23Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Error-when-trying-to-export-to-MS-Access-and-Excel/m-p/59864#M6090 Seems like a question for tech support. Wed, 29 Jul 2009 17:49:08 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Error-when-trying-to-export-to-MS-Access-and-Excel/m-p/59864#M6090 Doc_Duke 2009-07-29T17:49:08Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Error-when-trying-to-export-to-MS-Access-and-Excel/m-p/59865#M6091 Thanks. Here is the log.<BR /> <BR /> File To Export:<BR /> Table04_JoinAtrbHigh<BR /> <BR /> Output File Type:<BR /> Microsoft Access File (*.mdb)<BR /> <BR /> Options:<BR /> Use labels for column names : True<BR /> <BR /> Output File:<BR /> C:\Documents and Settings\nbkpxp4\My Documents\Table04_JoinAtrbHigh.mdb<BR /> <BR /> Total Processing Time:<BR /> 5.53125 seconds<BR /> <BR /> Error:<BR /> Attempt 3 : Unknown<BR /> at ADODB.RecordsetClass.AddNew(Object FieldList, Object Values)<BR /> at SAS.EG.DataAccess.DataModel.DaForJetEngineDataFiles.AddNewRecords(Object[,] a_arColValues)<BR /> at SAS.EG.DataAccess.DataModel.DataSourceManager.ExportToDataSource(String a_strTargetServer, String a_strActiveDataSource, DataSourceManager a_oTargetDSMgr, Boolean useLabelsAsColumnNames, Boolean copyIntegrityConstraints, String dateTimeFormatString)<BR /> at SAS.EG.DataAccess.DataModel.DataSourceManager.ExportToDataSource(OpenName openName, Boolean useLabelsAsColumnNames, Boolean copyIntegrityConstraints)<BR /> at SAS.EG.ProjectElements.DataExportHelper.Export(ProjectCollection project, ICanBeInputData sourceData, OpenName rawDestination, Boolean useLabelsAsColumnNames)<BR /> at SAS.EG.ProjectElements.ShortCutToData.Export(OpenName on)<BR /> at SAS.EG.ProjectElements.ExportTask.ExportRetry(IExportable iExportable, OpenName on, Int32 tryAgain)<BR /> Attempt 2 : Unknown<BR /> at ADODB.RecordsetClass.AddNew(Object FieldList, Object Values)<BR /> at SAS.EG.DataAccess.DataModel.DaForJetEngineDataFiles.AddNewRecords(Object[,] a_arColValues)<BR /> at SAS.EG.DataAccess.DataModel.DataSourceManager.ExportToDataSource(String a_strTargetServer, String a_strActiveDataSource, DataSourceManager a_oTargetDSMgr, Boolean useLabelsAsColumnNames, Boolean copyIntegrityConstraints, String dateTimeFormatString)<BR /> at SAS.EG.DataAccess.DataModel.DataSourceManager.ExportToDataSource(OpenName openName, Boolean useLabelsAsColumnNames, Boolean copyIntegrityConstraints)<BR /> at SAS.EG.ProjectElements.DataExportHelper.Export(ProjectCollection project, ICanBeInputData sourceData, OpenName rawDestination, Boolean useLabelsAsColumnNames)<BR /> at SAS.EG.ProjectElements.ShortCutToData.Export(OpenName on)<BR /> at SAS.EG.ProjectElements.ExportTask.ExportRetry(IExportable iExportable, OpenName on, Int32 tryAgain)<BR /> Attempt 1 : Unknown<BR /> at ADODB.RecordsetClass.AddNew(Object FieldList, Object Values)<BR /> at SAS.EG.DataAccess.DataModel.DaForJetEngineDataFiles.AddNewRecords(Object[,] a_arColValues)<BR /> at SAS.EG.DataAccess.DataModel.DataSourceManager.ExportToDataSource(String a_strTargetServer, String a_strActiveDataSource, DataSourceManager a_oTargetDSMgr, Boolean useLabelsAsColumnNames, Boolean copyIntegrityConstraints, String dateTimeFormatString)<BR /> at SAS.EG.DataAccess.DataModel.DataSourceManager.ExportToDataSource(OpenName openName, Boolean useLabelsAsColumnNames, Boolean copyIntegrityConstraints)<BR /> at SAS.EG.ProjectElements.DataExportHelper.Export(ProjectCollection project, ICanBeInputData sourceData, OpenName rawDestination, Boolean useLabelsAsColumnNames)<BR /> at SAS.EG.ProjectElements.ShortCutToData.Export(OpenName on)<BR /> at SAS.EG.ProjectElements.ExportTask.ExportRetry(IExportable iExportable, OpenName on, Int32 tryAgain) Wed, 29 Jul 2009 17:58:35 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Error-when-trying-to-export-to-MS-Access-and-Excel/m-p/59865#M6091 Mark_C 2009-07-29T17:58:35Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Error-when-trying-to-export-to-MS-Access-and-Excel/m-p/59866#M6092 As Doc@Duke indicated, this is a SAS tech support issue - suggest opening a SAS support track and provide them with detailed diagnostics information.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Wed, 29 Jul 2009 21:53:05 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Error-when-trying-to-export-to-MS-Access-and-Excel/m-p/59866#M6092 sbb 2009-07-29T21:53:05Z