I have an excel file that has been converted into a table. This table has one row with 3 fields (account# [unique] UtilityCo1, UtilityCo2, UtilityCo3, CustNo1, CustNo2 & CustNo3. I need to append this to a table where each account # is a separate record with one UtilityCo and one CustNo. When I try to do an append query I get Duplicate Output Destination. I would like for the query to create a new record with the same account # for each different utility co.