MySQL Forums
Forum List  »  Microsoft Access

Advanced Search
New Topic

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 ?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Import data from an excel spreadsheet into an mysql database
77430
Richard Conaway
April 24, 2008 11:52PM
Re: Import data from an excel spreadsheet into an mysql database
44846
Michael Markel
July 17, 2008 12:03PM
Re: Import data from an excel spreadsheet into an mysql database
18777
Richard Conaway
July 17, 2008 01:07PM
Re: Import data from an excel spreadsheet into an mysql database
13206
Mohammad Osman Goni
June 02, 2009 08:32AM
Re: Import data from an excel spreadsheet into an mysql database
14645
Toby White-Beebe
August 19, 2008 02:49PM
Re: Import data from an excel spreadsheet into an mysql database
10509
murali murali
November 20, 2008 02:27PM
Re: Import data from an excel spreadsheet into an mysql database
8846
Richard C
November 21, 2008 08:45AM
Re: Import data from an excel spreadsheet into an mysql database
12996
Son Tran
November 23, 2008 09:19PM
Import data from an excel spreadsheet into an mysql database
7432
sandeep sandeep
June 21, 2009 11:39PM
Import data from an excel spreadsheet into an mysql database
6570
suneel sharma
July 19, 2009 02:05AM
Re: Import data from an excel spreadsheet into an mysql database
10646
Jay Alverson
November 23, 2008 03:41PM
Re: Import data from an excel spreadsheet into an mysql database
8215
Matthew Adams
December 12, 2008 05:13PM
Re: Import data from an excel spreadsheet into an mysql database
7501
Jay Alverson
April 09, 2009 08:03AM
Re: Import data from an excel spreadsheet into an mysql database
6596
meenu khanna
April 07, 2009 03:01AM
Re: Import data from an excel spreadsheet into an mysql database
7743
Steven Bebsen
June 08, 2009 12:51PM
Re: Import data from an excel spreadsheet into an mysql database
8407
Jay Alverson
June 22, 2009 07:29AM


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.