-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
It is fairly easy to export access into a csv format and mysql will
gladly import that (and rather quickly too). You just need to write
the sql to create the tables matching access schemas and off you go.
BTW the relation (?) view of your database (in access) is your friend
when it comes to PK/FK...
Cheers,
Mike
- -----Original Message-----
From: W Luke [SMTP:[EMAIL PROTECTED]]
Sent: Friday, September 29, 2000 6:30 AM
To: CF-Talk
Subject: Re: Linux, MySql, NT, Access - which?
- ----- Original Message -----
From: "Ryan" <[EMAIL PROTECTED]>
Newsgroups: cf-talk
Sent: Friday, September 29, 2000 2:00 PM
Subject: Re: Linux, MySql, NT, Access - which?
> At 18:53 9/29/00 +1000, you wrote:
> >on 9/29/00 6:37 PM, W Luke at [EMAIL PROTECTED] wrote:
> >
> >> I have use of an excellent server in Telehouse Docklands that's
> >> running Linux; so my question to you is, should I go for Linux
> >> and MySql or
stick
> >> with the ease (IMO) of NT and Access? Incidentally if I go over
> >> to
MySql,
> >> is there an easy and bug-free way of converting Access Databases
> >> to
MySql?
>
> I have some vb code you can copy and paste into a module (or
> something..) in access and then run it, it will generate a text
> file with SQL
statements
> to create the tables in SQL, and I think it puts the data in there,
> too. Had to modify it a bit to get it working, but it works now.
> Let me know if you want it.
Sounds dead handy - would love a look, thanks.
Will
- ----------------------------------------------------------------------
- --------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal
k or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.3 for non-commercial use <http://www.pgp.com>
iQA/AwUBOdSl7HYFmKomMlANEQIo3gCdEimqOLSwdNGInRorKUXe9xvwekUAn3sI
kdsWWfufUo9IqpySjLw6zq4E
=HxVE
-----END PGP SIGNATURE-----
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
