sql server data mining: Hi!

I'm quite new to SQL Server, but has worked with Access for some time.

I receive datafiles once every day, in textfiles. I've set up a DTS import of the files and now I want to merge the data.
I have three different tables containing products that I would like to merge into one table. Also, there are duplicates in the tables, so I want the query to select only one with e.g. highest value.
I now how I could kinda' make this work in Access, but there are a total of 30 000 rows, so I would prefer to do it in SQL.

Any ideas?

Grateful for any help!

Cheers

Forwarding to a more appropriate newsgroup.

--
Raman Iyer
SQL Server Data Mining
[Please do not send email directly to this alias. This alias is for
newsgroup purposes and is intended to prevent automated spam. This posting
is provided "AS IS" with no warranties, and confers no rights.]
..

[quoted text, click to view]
merge into one table. Also, there are duplicates in the tables, so I want
the query to select only one with e.g. highest value.
[quoted text, click to view]