I have two databases. The first is Access, the second is MySQL. Due
to security, the two computer networks they are on are not connected.
How can I transfer binary data (just one table) from the Access
database to the MySQL. I will probable be using a jump drive, as both
computers only have floppy support, and the table is too large to fit
on one.
I was thinking that I could export the database as a delimited file,
but do to its binary format, I don't know what I could use to separate
the columns.
bibi.skuk - 21 Oct 2004 15:21 GMT
> I have two databases. The first is Access, the second is MySQL. Due
> to security, the two computer networks they are on are not connected.
[quoted text clipped - 6 lines]
> but do to its binary format, I don't know what I could use to separate
> the columns.
If u want, u can use this Php script... with this, u can transfert an
acces table to a Mysql table.
http://www.nexen.net/scripts/details.php?scripts=608
fosheezy95 - 27 Oct 2004 06:46 GMT
> I have two databases. The first is Access, the second is MySQL. Due
> to security, the two computer networks they are on are not connected.
> How can I transfer binary data (just one table) from the Access
> database to the MySQL.
I recommend emailing the people at http://www.software-labs.net/ as
they have software that may handle this. Don't know if you are
looking for a "quick fix" solution or a more permanent one. Maybe you
can email them as they can provide some feedback at least. Cheers