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 < myt
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 follow
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.
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 ta
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 di
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.
T