• Thanks a ton, guys!

    What I was trying to do was -

    I had been given the task to compare three systems (similar working but 3 versions for 3 diff clients) and chart it out so we could integrate all 3 into 1.

    So I thought I'd first have to check all tables, columns, data types, lengths, etc. etc.

    What I did was this -

    I fired the query to load these results into SQL tables in the 3 resp. DBs.

    I then went to Excel and Imported the 3 tables 🙂

    That took me like 3 mins..?? Yea, I think so.

    Served the pupose.

    Problem is, I was first looking at doing it from the query window. That didn't work

    Next, I thought I'd create a linked server to Word or Excel to export the data but somehow I kept getting Driver errors and stuff I couldn't figure out. (I'll see if I can reproduce those errors so I have some info here..)

    I gave up on all that and just did what I did. and all that sweat.... for nothing. I really didn't learn a thing! 🙁