there is no command line.. you go to the mysql.com site, download
the access converter on the contributed programs page, copy the code
into an access module (macro), edit the code to tell it where to
save the result and run it.
It will produce a text file, then you can do
mysql mydatabase < mytextfile_fromaccess
Chris Wilkinson wrote:
>
> Can you give me a sample command line please
>
> 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
