PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

MS ACCESS and multiple tables

Gravity Support Forums » Plugin Support » Gravity Forms

  1. Mattingly Graphics
    Member

    I have a client who has forms for user submission. The end target is Access... sort of. They don't need access as a database, but rather for querying and producing reports. The exported CSV adds a few extra steps, and we haven't been able to develop a workflow which allows allows them to simply export new entries, and have them properly import into access, purge for duplicates, etc...

    So I'm in the process of simply allowing Access to connect to the MySQL database tables for the RG_Leads tables. I can get in just fine, and the tables pull down great. But there are 3 of them. Now I need to run a Union query to pull the necessary data from the three different tables and populate a new table with that data.

    Has anyone had experience doing this? Any guidance or suggestions?

    Thanks!

    Posted 11 years ago on Friday March 8, 2013 | Permalink

  2. Chris Hajer
    Key Master

    This is outside the support we can offer here in the Gravity Help support forums. Sounds like you are on your way by allowing external connections to your MySQL database from Access. The UNION and SQL support is something we can't help you with. There are many resources online for help with SQL though. Here is one: http://www.mysqltutorial.org/sql-union-mysql.aspx

    Posted 11 years ago on Wednesday March 13, 2013 | Permalink

This topic has been resolved and has been closed to new replies.