# Open SQL database with Excel, keep it relational?

**URL:** <https://forum.kirupa.com/t/open-sql-database-with-excel-keep-it-relational/302615>\
**Category:** Uncategorized\
**Created:** [January 4, 2010, 11:16am UTC](https://forum.kirupa.com/t/open-sql-database-with-excel-keep-it-relational/302615 "2010-01-04T11:16:11Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![mlk](https://avatars.discourse-cdn.com/v4/letter/m/e56c9b/32.png) [@mlk](https://forum.kirupa.com/u/mlk)\
**Post date:** [January 4, 2010, 11:16am UTC](https://forum.kirupa.com/t/open-sql-database-with-excel-keep-it-relational/302615/1 "2010-01-04T11:16:11Z")

</div>

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)