none
SQL QUERY working in database but not working when copied and pasted into excel spreadsheet RRS feed

  • Question

  • SQL QUERY working in database but not working when copied and pasted into excel spreadsheet:

    The query in SQL works fine: 

    SELECT top (1000)
          [Date]
          ,[PortfolioID]
          ,[SectionID]
          ,[Market_value_pfolio]
       ,[Portfolio]
      
     FROM [GIBRisk].[dbo].[tbl_var_top]
     
      INNER JOIN [tbl_portfolio]
      ON [tbl_var_top].PortfolioID = [tbl_portfolio].ID

    But when copied into microsoft access SQL query i get the below error:

    'Could not add the table [GIBRisk].[dbo].[tbl_var_top]'.

    thx for advice in advance

    Tuesday, October 20, 2020 5:01 PM

All replies