Not to worry - figured it oout...if anyone is interested - this is what I had to do...

myRange3.PasteSpecial(3) (the 3 is apparently equivalent to Paste values - couldn't find any...

B/c of the goofy header rows in this file whenever I try to get the file to a different format using DTS is drops the last column out and nulls...

Thanks so much for all of the responses!

Erin

I found the info in the help file on how to add an Excel linked server, it looks like you might need to set a named range to refer to...

Thanks Herb -

I have last row set to 3000 (there are about 2700 records in the Excel file).  I am not using a named range.  How do I create...