2 Replies Latest reply on May 28, 2012 1:35 PM by gal.rimon

    Microsoft JET database error 0x80040E14: Duplicate output alias 'DivisionID'.

      I try to connect to 2 simple text files

      one table is Divisions, with key DivisionID

      the other is Customers, with a DivisionID as a dimension

      I join between them and

       

      I receive the above msg

       

       

      SELECT TOP 10000 [Customers#txt].[City] AS [City],

        [Customers#txt].[CompanyName] AS [CompanyName],

        [Customers#txt].[ContactName] AS [ContactName],

        [Customers#txt].[Country] AS [Country],

        [Customers#txt].[Customer] AS [Customer],

        [Customers#txt].[Department] AS [Department],

        [Customers#txt].[DivisionID] AS [DivisionID],

        [Divisions#txt].[DivisionName] AS [DivisionName],

        [Customers#txt].[EntryType] AS [EntryType],

        [Customers#txt].[Fax] AS [Fax],

        1 AS [Number of Records],

        [Customers#txt].[Phone] AS [Phone],

        [Customers#txt].[PostalCode] AS [PostalCode],

        [Customers#txt].[PreferredPhoneNumberID] AS [PreferredPhoneNumberID],

        [Customers#txt].[QueueID] AS [QueueID],

        [Customers#txt].[StateProvince] AS [StateProvince],

        [Customers#txt].[CustomerID] AS [CustomerID],

        [Divisions#txt].[DivisionID] AS [DivisionID]

      FROM [Divisions#txt]

        LEFT JOIN [Customers#txt] ON [Divisions#txt].[DivisionID] = [Customers#txt].[DivisionID]