On the mysql.com website under downloads: contributed there
is a chunk of VBA code you can put in an access database to make
it export to a SQL text file, use that, you are better off,
otherwise export from Access to text (comma separated for example)
and use LOAD DATA in mysql to load the file.
Chris Wilkinson wrote:
>
> Steve
>
> Thanks for replying. I have an Access 2000 database called webugnet and
> I am attempting to Export it. I have installed MyODBC and configured a
> mysql connection to the sql server on DSVR.
>
> So, in the table window right click on the database and select "Export"
> This brings up an "Export table to:" window In "Save As" select "ODBC"
> and this brings up a window "Export webugnet to webugnet in ODBC
> database".
>
> Click "OK" and this brings up a window "Select Data Source" and on this
> select "Machine Data Source"
>
> Select the mysql connection with the correct database and click OK
>
> Then up comes the error. I previously got a wrong user name and
> password error but solved that one by correct configuration.
>
> Hope you can follow what I am doing or doing wrong from this.
>
> CHRIS
>
> In message <[EMAIL PROTECTED]>, Steve Ruby
> <[EMAIL PROTECTED]> writes
> >Chris Wilkinson wrote:
> >>
> >> I am attempting to upload an Access db to a remote mysql server - at
> >> dsvr in the UK.
> >>
> >> I get connected (I think) but receive the following error message:
> >> Microsoft Access ODBC - call failed [Microsoft][ODBC Driver Manager #0]
> >>
> >> Can you point me in the right direction for this or offer some help.
> >>
> >> Thanks
> >>
> >> CHRIS
> >> --
> >> Chris Wilkinson
> >
> >
> >You need to explain better what you are doing. You cannot upload
> >an Access DB to a MySQL server. You can upload and insert the data, you
> >can write some program to make calls to both DBs and insert the data
> >but you can't just upload the database?
> >
> >And where are you getting the error from, that error is from Access
> >not mysql?
>
> --
> Chris Wilkinson
---------------------------------------------------------------------
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
