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
There are far more elegant ways to do it. But for such a small file, the
looping-through-and-writing-sql-inserts-one-at-a-time should work just fine.
As long as you don't have to do it more than once, and the file is so small,
that's what I'd do. I've done it that way before.
An even uglier way:
5 matches
Mail list logo
