There are two methods that I commonly use to move data from mySql into
Access.
The first is to use a myODBC connection and simply import the tables. Given
the size of your database (small that is) this would be quite quick assuming
that you are able to establish an ODBC connection to your database accross
the net (I bet you can). If you haven't already, you should dl and install
myODBC. Be warned though, if your database is large (many of my tables have
> 1 million records) this method of import can be quite slow (even for
Access).
The second method is select your files into "OUTFILE"s and then import them
into Access using the text import wizard. The select statement would look
something like this:
SELECT * INTO OUTFILE '<put your filename here>'
FROM <put your table name here>
Note: If your table contains binary data, you won't be able to use this
method.
The second method is generally quicker but has a couple of downsides:
- It will not create your table definition for you! You will have to
either:
1. pre-define your table and then import into it
2. define your table through the import-text wizard (see the advanced
button)
3. import it and then go back and massage the field definitions.
- For options 2 and 3 be carefull! Access only scans so many rows (50?) to
decide what type to assign an import field. This often leads to import
errors. Also note that Access will always default text fields to a length
of 255 which may cause unnecessary overhead if your fields are in fact
smaller (and most, of course, are).
Because Access' table definition is pretty time consuming to use, I
sometimes first do a "SHOW COLUMNS" into a text file and then use EXCEL to
massage that result set into a CREATE TABLE DDL query (many people don't
know that Access supports DDL queries). After I have the table set up, I
import into that table.
> -----Original Message-----
> From: Neil Tompkins [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, September 22, 2001 1:11 PM
> To: [EMAIL PROTECTED]
> Subject: Backup Data
>
>
> Hello,
>
> I currently have about 2500 records in a mySQL database that is
> hosted with
> my ISP. I am very familar with MS Access. Is it possible that I
> can backup
> my data into a MS Access database ? Any advice would be very grateful !
>
> Thanks
>
> Neil
> www.advertising-online.net
>
> ---------------------------------------------------------------------
> 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
>
>
---------------------------------------------------------------------
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
