So long as the user has access to both the Access database and the MySQL database, then theoretically, what you are proposing should not be a problem. I am afraid that I don't know of a pre-made script to do that, however. If Access has enough sophistication that would allow a user to submit a SQL query that will automatically dump all data and tables out to a flat file (like MySQL) has, then it should be relatively easy to do. You may need to research this a bit to see what Access is capable of. It has been a long time since I've used Access, and its support for more advanced capabilities of SQL escape me at the moment.
-- Steve - Web Application Developer http://www.sdwebsystems.com nickvansmack9 wrote: > > > John & Steve, thanks for the reply. That's good to know. Is it possible > to create a frontend > on a webpage where they can process it through the browser sort of like > doing an > "attachment" like in Yahoomail. I mean, completely upload from a webpage? > > Know of any scripts that can do this? > > Thanks! > nick > > --- In [email protected] <mailto:php_mysql%40yahoogroups.com>, > Steve <[EMAIL PROTECTED]> wrote: > > > > That's exactly what I was going to say. Simply export your database > > tables to some kind of flat file and use that file to import the data > > into your MySQL database. > > > > -- > > Steve - Web Application Developer > > http://www.sdwebsystems.com <http://www.sdwebsystems.com>
