Export the data you are interested in as comma separated file.
Then use the LOAD DATA INFILE - command in mysql, via the terminal or
phpmyadmin.
From the manual:
13.1.5 LOAD DATA INFILE Syntax
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt'
[REPLACE | IGNORE]
INTO
On Mon, 2004-01-19 at 22:24, Tim Thorburn wrote:
Now, the question is - how to connect PHP to MS Access? I've done some
searching on Google - most pages say wow, good luck with that or
something similar - any thoughts? I'm sure someone has had to do this
before - am I on the right track
Actually I found an even better program on mysql.com called MyDbConverter -
converted the Access database into MySQL in a whole wopping second - now
just needs a little cleanup and I can put it into the new table I've
already created.
Thanks for all the help
-Tim
At 09:34 AM 1/20/2004, Brian V
Hi,
Ok, I know I've already spoken blasphemy ... but hear me out. I have a
client who wants to move her real estate site from a local ISP to a
somewhat decent service. Currently her site is all in Access/ASP - since I
know not of that world, I'm converting it to MySQL/PHP. The person they
. And, embarrassed as I am to admit it, I've
done it that way, too. ;)
Joey
www.moderntales.com
- Original Message -
From: Tim Thorburn [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, January 19, 2004 10:24 PM
Subject: [PHP] connecting PHP to MS Access
Hi,
Ok, I know I've already
Hi,
Tuesday, January 20, 2004, 1:24:46 PM, you wrote:
TT Hi,
TT Ok, I know I've already spoken blasphemy ... but hear me out. I have a
TT client who wants to move her real estate site from a local ISP to a
TT somewhat decent service. Currently her site is all in Access/ASP - since I
TT know not
6 matches
Mail list logo