Quote:
|
Originally Posted by foggy
I guess this one would have been better off posted on the Microsoft Community website for Access and Excel. Probably no one on this site uses SQL to be able to make an informed suggestion to my query.
Thanks to anyone who may have given it thought.
|
SQL is basically a query language that you can use on databases.
Excel is inherently slow once you get over a certain data size and while it's attractive because it's relatively easy to get going, one soon finds out the limitations.
Access is an alternative as are half dozen other databases, but you don't have to use the Access programming language to manipulate the data.
If you can use Excel (VBA) language you are half way there, you can use Visual Basic or VB.NET or any other programming language in conjunction with SQL, while Access is acting as a mere repository of your data.
I think there is even a free database available with Open Office.
True, the learning curve may be steep, but your other options are limited, the best you could do is to break up your sheets further into smaller data sheets, based on dates or locations and link them.
Whichever way you go it will take some learning.
Good luck