Have a look at MyAccess available from http://www.accessmysql.com it has
worked for me
Alex
-Original Message-
From: andy thomas [mailto:[EMAIL PROTECTED]]
Sent: 21 March 2002 09:14
To: [EMAIL PROTECTED]
Subject: MS Access to MySQL conversion
We have a Unix server which in addition to
Steve, Doug & Gordan,
Thanks for taking the time to help me.
Billy
- Original Message -
From: "Steve Rapaport" <[EMAIL PROTECTED]>
To: "Billy Reed" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, December 28, 2001 2:17 AM
Subject: Re:
Instead of TOP 5 DistKm FROM SCLeague
you can probably use
DistKm SORTED BY DistKm DESCENDING LIMIT 5
The rest about temp files is probably best to read
Goran Bobic's mail.
Billy Reed wrote:
> I am new to MySQL and am trying to convert :
>
> SELECT SUM(DistKm) AS Distance FROM (SELECT TOP 5
On Thursday 27 Dec 2001 23:31, Billy Reed wrote:
> I am new to MySQL and am trying to convert :
>
> SELECT SUM(DistKm) AS Distance FROM (SELECT TOP 5 DistKm FROM XCLeague
> WHERE LoginID='billyreed' AND HGPG='PG' ORDER BY DistKm DESC)
>
> Can anyone suggest how this is done in MySQL. It doesnt see
I used MyAccess2000, it connects through ODBC inside Access. You can create
tables, import Access to MySQL or MySQL to Access and it will display table
SQL and indexes, its $30usd http://www.accessmysql.com/
-Original Message-
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent: Mond
The Jonathan Tutorial
Access -2- MySQL in 8 Not-Extremely-Easy-But-Not-Hard Steps
1. Go to mysql.com
2. Download and install MyODBC
3. Set up a new ODBC connection for the new mySQL server
4. Open up the database in access
5. Go to the File menu and choose to Export (Tables?)
6. At the bottom of
try this:
http://www.mysql.com/downloads/contrib.html#SEC653
-Original Message-
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 22, 2001 2:12 PM
To: [EMAIL PROTECTED]
Subject: MS Access to MySQL conversion? How?
I am new to this fast database and love MySQL, but I
At 8:37 AM +0700 5/4/01, Taing Nguon wrote:
>Dear Sir/Madam
>
> I just know that there is a tool to convert database from MS Access
>to Mysql, But I do not know the URL of this tool. Could you tell me this
>URL? Thanks
Check this page and look in the "converters" section. Might be what you
w
