Is this possible ?
Can I possibly have a SQL database opened with excel ? I’m wondering for development testing if it’s possible to have tables interact with each other using macros or linked sheets (ie column A from table 1 is used in column B from table 2)
does anyone know if such a tool has been written ?
Thanks
mlk
(ps I use mysql on my server if that’s of use)
