Importing / OLE DB Query
 

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 Wrote:
"nkippen" wrote in message
...

I don't know exactly to what forum I should be posting thi
question,
so I thought I'd start here with the gurus.

A fine choice. excel.querydao would have been okay too.


Is there away that I can import only the newly added accounts to my
copy of the excel document on my desktop, that way all the accounts
that I have color coded remain color coded and I can easily go down
through the list analyzing only the newly added accounts to th
excel
document that is updated weekly?

Or in other words is there a way to only import the newly added
accounts to my excel document without having to import the entire
document thus overwriting everything that I have done?

Is there some parameters I need to use in my Query options with the
Importing tool? Or will I have to come up with some Visual Basi
Macro
or something to be able to do this?

I don't think so. You can definitely import only new records, bu
that's
all that will be the new records. The old ones will be gone an
you
don't want that. I would probably make a separate table of previously
analyzed records using some kind of unique field to identify them and
code
to determine what color they should be. Then I would use VBA t
re-color
the rows after the query table was refreshed. In as separate fil
(an
excel file or even a text file) you could have information like

1001 Blue
1003 Red
1010 Blue

and the macro would read down this file and color the rows the wa
they
were. Another macro could update the file when you're done analyzin
the
new records to record their colors. You definitely need some way to
uniquely identify those records.

If this sounds like something you want to try and you need some help
implementing it, post back.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.co

--
nkippe
-----------------------------------------------------------------------
nkippen's Profile: http://www.excelforum.com/member.php...fo&userid=1548
View this thread: http://www.excelforum.com/showthread.php?threadid=27061

Importing / OLE DB Query
 

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?


--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com