|
|
Posted by Michael Vilain on 06/18/05 12:56
In article <42b3eb4c$0$38038$5a6aecb4@news.aaisp.net.uk>,
"Mike MacSween" <mike.macsween.getlostspammers@btinternet.com> wrote:
> My client has an MS Access database application on her local machine. I have
> full access to that in terms of changing the design.
>
> I've got a simple PHP/MySql application on shared hosting, so no direct
> access to the db server.
>
> I'd like to give her the facility to export the information in her local
> Access application to the shared PHP/MySql site. From one command button (or
> similar) in the Access application.
>
> It would be probably be a complete overwrite. That is to say all the
> information on the shared site would be overwritten with that from the local
> machine.
>
> I'm assuming that I'd have to make an HTTP request to some PHP page which
> would then run the SQL to delete all the records, then append all the new
> ones.
>
> Is this the right approach? I don't want to spend weeks finding out that
> this is fundamentally flawed in some way. The client has an ADSL connection.
>
> Yours, Mike MacSween
You'd have to write a php script that generates a access import file.
I'm not that familiar with Access, so I can't comment further on "how",
but I'm sure there are Access books out there that will tell you how to
do "file import". All you have to do is create the output from your
MySQL database in perl or php accordingly and output it as an Access
export document.
One why to try this is to take the client's database and export it.
Create your output in a similar format.
--
DeeDee, don't press that button! DeeDee! NO! Dee...
Navigation:
[Reply to this message]
|