Dear Friends,
I'm getting "The table name you entered doesn't follow TOSS System object-nameing rules." error when executing below code in MS Access using VBA.
strSelectSQL = " SELECT SU.CUSTOMER, SU.ISIN_NO, SU.TURNOVER, SU.SOURCE, MAP.OVERVIEW, ADV.SUB_ADV " & _
" FROM tbl_Details_YTD AS SU, tbl_Mapping AS MAPPING, tbl_Advisor AS ADV " & _
" WHERE SU.SOURCE = " & gsSource & " AND SU.REPORTING_PERIOD = " & Me!txtReportingMonth & " AND SU.GROUP_CODE=MAPPING.Mapping_Code And ADV.RM_CODE=SU.RM "
Set rsTmp = gsTOSSDatabase.OpenRecordset(strSelectSQL)
strFile = Me.Output_Dir & "\" & Format(Now(), "yyyymmdd") & Format(Now(), "hhmm") & "_TOSS_" & Format(Me.txtReportingMonth, "mmm") & Format(Me.txtReportingMonth, "yy") & ".xls"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, strSelectSQL, strFile, True
I have data in different database (TOSS.mdb file) and code in different database (TOSSProg.mdb file) that's why I can't use Query while exporting data into excel. I can't create / keep query in (TOSSProg.mdb file).
Thanks
Ria
I'm getting "The table name you entered doesn't follow TOSS System object-nameing rules." error when executing below code in MS Access using VBA.
strSelectSQL = " SELECT SU.CUSTOMER, SU.ISIN_NO, SU.TURNOVER, SU.SOURCE, MAP.OVERVIEW, ADV.SUB_ADV " & _
" FROM tbl_Details_YTD AS SU, tbl_Mapping AS MAPPING, tbl_Advisor AS ADV " & _
" WHERE SU.SOURCE = " & gsSource & " AND SU.REPORTING_PERIOD = " & Me!txtReportingMonth & " AND SU.GROUP_CODE=MAPPING.Mapping_Code And ADV.RM_CODE=SU.RM "
Set rsTmp = gsTOSSDatabase.OpenRecordset(strSelectSQL)
strFile = Me.Output_Dir & "\" & Format(Now(), "yyyymmdd") & Format(Now(), "hhmm") & "_TOSS_" & Format(Me.txtReportingMonth, "mmm") & Format(Me.txtReportingMonth, "yy") & ".xls"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, strSelectSQL, strFile, True
I have data in different database (TOSS.mdb file) and code in different database (TOSSProg.mdb file) that's why I can't use Query while exporting data into excel. I can't create / keep query in (TOSSProg.mdb file).
Thanks
Ria