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
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 t
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
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
gly, ugly, ugly. But it works. 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:
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
h
6 matches
Mail list logo
