Posted by Mike MacSween on 06/18/05 13:06

Thanks. I think you may have misunderstood. I want to get data FROM the
Access database and INTO the MySQL database.

"Michael Vilain" <vilain@spamcop.net> wrote in message
news:vilain-D86499.02562918062005@comcast.dca.giganews.com...
> 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...
>
>
>

[Back to original message]