Not sure what the purpose is here. However, if you establish an ESS connection to the MySQL table then you can use the Server system DSN to also allow users to import from the FileMaker file to itself. IOW, have FileMaker import it through its own file but with a layout that references the ESS table.
Again I dont know the purpose here but another option is to allow the server to do the importing for you but then that would have to be a server side script.
Thanks for the response Mr_Vodka.
I think the best solution will be to use the ESS tables. I am not sure how to import records from one table to another within a database. Can you explain the best method to do this using a script? I am sure it must be simple, but for some reason I have never had to do this before. :)
The end use is that we have a registration website that writes data to a MySQL Database. Then the records are imported into the FMP Database for further processing. I feel it works best as an "Import" because there are a number of scripted steps that get applied to the data in the import process and I like keeping the data from the FMP Database and the MySQL database separate from each other. This is why I am importing the data into a table rather than just using ESS to have the data mirrored in the two DBs.
Whoops! I guess I do know how to import records from the same file. I figured it out when I thought about it for more than 10 seconds. :) For some reason it seems counter-intuitive to do a record import and choose the same file you are currently working with, but obviously it works.
Anyways, this appears to be working great and makes it so that I don't have to purchase additional licenses of the ODBC driver.
Thanks so much for the help!
We have been using the Actual Technologies ODBC Driver. I was unaware of that free driver. Thanks for the tip! :)