I have created a tool for my organization to use that stores large amounts of data in a flat data table. Naturally, that is not the best solution for editing, updating, and access.
For reasons beyond my control, I cannot create the application in access or even store the data in a database application. I know I can structure my Excel lists in separate data table to mimic a relational database, but can I use MS query to access those tables via SQL?
For reasons beyond my control, I cannot create the application in access or even store the data in a database application. I know I can structure my Excel lists in separate data table to mimic a relational database, but can I use MS query to access those tables via SQL?