MySQL Forums
Forum List  »  Microsoft Access

Cannot retrive data migrated from ms access
Posted by: Rudranee Kavthekar
Date: December 31, 2010 04:46AM

I have migrated data from MS Access to MySQL. For this I exported the tables to text files and then imported the text files to MySQL DB.
The data has double quotes around it for string values, which is causing problem.
How should I solve this problem?
My project is in JSP.

Sample table from MySQL:

mysql> select * from Status;
| Status |
| "DR0" |
| "DR1" |
| "DR2" |
| "DR3" |
| "DR4" |
5 rows in set (0.01 sec)

Thanks in advance for your help.

Options: ReplyQuote

Written By
Cannot retrive data migrated from ms access
December 31, 2010 04:46AM

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.