I agree with Welsh Corgi; this sounds like a one time comparison, so there's no real need to add a linked server.
I would use the Import wizard, just has Welsh suggested, bring the table into teh database, adn join it to your transactions table.
then you can grab hte data and paste it into an excel and report back really quickly.
Lowell
--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!