Importing / OLE DB Query

[nkippen]

I would appreciate any additional help you can offer. Just so you know
my skill level is probably between an Intermediate and Expert user o
Excel. I understand the concept that you're explaining, bu
implementing it by myself would prove to be a very difficult task fo
me.

-N. Kippen

 

[Dick Kusleika]

N

For some reason, posts from excelforum don't thread properly in my
newsreader. Posts that are replies to my post show up in red so that I
don't miss them, but your post isn't a reply to mine, but to your original
one. If you like to use excelforum instead of connecting directly to the MS
servers, you should complain about that. In the mean time, if I don't reply
to you it probably means I missed your post.

I would appreciate any additional help you can offer. Just so you know,
my skill level is probably between an Intermediate and Expert user of
Excel. I understand the concept that you're explaining, but
implementing it by myself would prove to be a very difficult task for
me.

I need some details. What does your data look like? How many colors do you
use and what do they mean? What is unique about each record? Do records
every fall off the report or are they on there forever? Are you refreshing
an external data table that exists in the same workbook each time, or are
you creating a new external data table in a new workbook?