MySQL Forums
Forum List  »  Microsoft Access

Re: Cannot retrive data migrated from ms access
Posted by: Devart Team
Date: January 11, 2011 08:38AM

Try this query -
UPDATE table1 SET column1 = TRIM(BOTH '"' FROM column1);

Also, have a look at Data Import tool (Access format) in dbForge Studio for MySQL. This tool can help you to migrate data fom the MS Access.

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Cannot retrive data migrated from ms access
1260
January 11, 2011 08:38AM


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.