MySQL Forums
Forum List  »  Microsoft Access

Re: Import data from an excel spreadsheet into an mysql database
Posted by: Toby White-Beebe
Date: August 19, 2008 02:49PM

Hello Richard,

I have been successful in importing the CSV file, only after I stripped off the trailing field delimiters ',,,,' off of each line to be imported ? I did use the standard Import/File Location/ANSII/CSV using Load Data/Replace Data with File, Ignore Duplicate Rows, Fields Terminated by (,) without parands... everything else is default values.

I, on the otherhand, am having minor issues with importing Currency Fields and have the values appear, with or without the ($) ? The field value is set at Decimal/8,2/not null/MIME type (text/plain)/Browser Transformation (text/plain: formatted) ?

Can anyone help me set up the field properly to show ANY numeric value ?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Import data from an excel spreadsheet into an mysql database
14432
August 19, 2008 02:49PM


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.