Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Union Query | Excel Discussion (Misc queries) | |||
Importing access query | Excel Discussion (Misc queries) | |||
Importing Data via Web Query - Can values be passed to query? | Excel Discussion (Misc queries) | |||
Importing / OLE DB Query | Excel Programming | |||
Problem importing using MS Query | Excel Programming |