Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
RecordSet & New Class - Good idea?
Hi All, I have the following situation: A database held in an access mdb file. The data is pulled out into an excel front-end by use of a RecordSet object (CopyFromRecordSet is used to populate a worksheet range). There are about 1600 records currently (growing) and 32 fields per record (about 50,000 data points). Changes made to the worksheet are then transferred back to the mdb using the update method of the recordset object. Users do not access the worksheet directly - data is presented to them in a userform that they amend if necessary and then update to the worksheet (which then goes back to the mdb). The reason for the Excel front end is that it already exists (the original data was stored in a worksheet and later moved to an mdb due to issues with shared workbooks being flaky), it works, and we don't really want to invest time and effort to replicate something that is already there. Question: Would it be better to avoid puttig the data into a worksheet range, and instead create a new class object containing each of the records, with the fields being properties of the objects? Would it be faster / better? Thanks for any comments you have. If you need more information, please do post a question - I have tried to give the salient points without going into too much detail, but not having used classes before I may be missing a point somewhere! Thanks, Alan. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
And in case I don't see you,good afternoon,good evening,and good n | Excel Discussion (Misc queries) | |||
Share a company workbook-Good idea or asking for trouble? | Excel Discussion (Misc queries) | |||
Protected Workbook - Not a Good Idea! | Excel Discussion (Misc queries) | |||
Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good | Excel Programming | |||
Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good you | Excel Programming |