This is something I have never done, but an curious on how it would work. I
have been looking around here and on Google, but haven't quite found what I
am looking for. To be upfront my preference would be to just keep this
entire system I am going to discuss in Access, but NO ONE at my work besides
me knows how to use Access. So we end up with 50MB & 30MB Excel files that
contain one HUGE worksheet that is 47000+ lines of data.
So my question is if I made an overlay of Excel to Access
is this something
that would reduce the size of the Excel files thus increasing performance? I
looked at the MS Query and can see how to get the basic data into Excel from
Access, but it seems that the Excel file is still large (ie the query's data
is imported not viewed)...
How can I just have Excel view the data in Access, but not store it into the
Additionally, can someone give me direction on how to also use Excel to edit
the data in the Access Tables (via DAO preferably), do I just use SQL APPEND
or INSERT INTO? How does Access know what to do with edited cells?
I know this is a lot of stuff so I hope some
of you have taken the time to
read down this far, thank you in advance for you assistance.
-Steven M. Britton