MySQL Forums
Forum List  »  Microsoft Access

Two word table names from access database migration
Posted by: B Rucka
Date: October 13, 2005 02:47PM

Download lastest MYSQL 5.0.13-rc-nt. Used the Migation Tool on a access .mdb file. Conversion worked great. Access database contained tables with names containing multiple words separated by spaces (MY TABLE ONE). The Migration tool created and imported a table called MY TABLE ONE . The SHOW TABLES command display the table MY TABLE ONE yet get error with SELECT * FROM MY TABLE ONE I get error 1064 (42000) How cant I correct this problem. thanx

Options: ReplyQuote

Written By
Two word table names from access database migration
October 13, 2005 02:47PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.