access 95 and MySQL - Richard Dobson - com.mysql.lists.myodbc

3 messages in com.mysql.lists.myodbcaccess 95 and MySQL

From	Sent On	Attachments
Richard Dobson	11 Oct 2001 10:15
Venu	11 Oct 2001 10:39
Venu	15 Oct 2001 10:31

Subject:	access 95 and MySQL
From:	Richard Dobson (rich...@hotmail.com)
Date:	10/11/2001 10:15:43 AM
List:	com.mysql.lists.myodbc

Hi, I can connect to MySQL using MyODBC from Access95 and can link tables but when it comes to exporting the tables from access into MySQL I am presented with the following error message:

[TCX][Myodbc] Unknown table 'tablename' (#1051)

This suggests that it can't find the table within the access DB. This DB is replicated but apart from that there is nothing weird about it. Anybody any ideas?

As an alternative I have tried to create an SQL pass through query in Access. Is it possible to append a MySQL table with data from an access table?

i.e insert into Ph_ABP(Member_ID) select Member_ID from c:\Windows\Desktop\db1.ABP

It's complaining that there is a syntax error in the path name.

Any help woukld be greatly appreciated cheers