Hi Jose,
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jose
> Gerardo Amaya Giron
> Sent: Thursday, November 22, 2001 1:11 PM
> To: [EMAIL PROTECTED]
> Subject: MySQL Newbie and Access Database
>
>
> Hello all, I just start up with mysql so I have some stupid questions to
> ask.
>
> right now I have an MS Access database with one table that has 25 fields
> and like 2000 records in it. I'm trying to move to MySQL in order to
> have a better DB. I can define the database and the table manually
> that's not a problem, My problem is how can I export the 2000+ records
> from the Access DB to MySQL DB. does an export file from access do the
> job???
> I read a little bit about myODBC, does myODBC help me in this situation,
> does it help me export all the records to the new database???
Yes. You can make use of MyODBC to export tables and/or associted
data from MS Access to MySQL.
Here is the snippet from new MyODBC manual on how to export data
from MS Access to MySQL.
Q. Export a table or query to MySQL using MyODBC data source
Note: You can only export a table or query to MySQL server,
if you have installed the latest MyODBC driver 2.50.38
or grater, else you will experince problems with text
and varchar data types.
1. In the Database window (The window that appears when you
open an Access database or an Access project. It displays
shortcuts for creating new database objects and opening
existing objects.), click the name of the table or
query you want to export, and then on the File menu, click
Export.
2. In the Export Object Type 'Object name' To dialog box, in the
Save As Type box, click ODBC Databases ().
3. In the Export dialog box, enter a name for the file (or use
the suggested name), and then click OK.
The Select Data Source dialog box is displayed; it lists the
defined data sources for any ODBC drivers installed on your
computer.
4. Click either the File Data Source or Machine Data Source tab,
and then double-click the MyODBC data source that you want to
export to
To define a new data source for MyODBC driver, please follow
the instructions from:
http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#Installi
ng_MyODBC
5. Microsoft Access connects to the MySQL server through MyODBC
data source and creates the new table in the server.
Regards, venu
--
For technical support contracts, go to https://order.mysql.com
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
/_/ /_/\_, /___/\___\_\___/ California, USA
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
