Importing Price Lists 8.03

I'm currently having an issue with setting up Price List in the
Customer Maintenance. I know there is a separate table called
CustomerPriceList. I have opened that up via an ODBC connection. I
can manually add a price list to the table and it works fine. However
I have an excess of 5,000 customers and would rather not manually set
the price list hierarchy for each customer. I try to paste the info
into the table from an excel file and it saves it in the table, but
doesn't add it to the customer. Is there some sort of validation that
it does when you type them in manually that isn't happening with a
copy and paste? I really DON'T want to manually type 5,000+ customers in.

Thanks

Rob Dailey