|
05-14-2005, 06:46 PM
|
#1 |
|
Junior Member
Join Date: May 2005
Posts: 1
|
Importing CSV file for numeric columns
I exported a table in another database to a CSV format
 with fields delimited by " and separated by commas.Numeric columns cannot be imported into mysql tables from this format. Numeric values are treated as strings by the LOAD command. What are suggestions for handling this. Should I import the file to an intermediate table with all string definitions for the columns? If so, how do I convert a string value to a numeric value when I load it into the target table? |
|
|
|
05-15-2005, 03:10 AM
|
#2 |
|
Member
Join Date: Feb 2005
Location: ANtwerp - Belgium
Posts: 32
|
Re: Importing CSV file for numeric columns
If I were you, I'd download navicat, the trial version. Navicat can easily read in XL files, so I suppose csv won't be a problem either.
Navicat isn't free but the trial version can be used for 30 days. Try it out or take a look at other GUI's who give you the possibility of managing your MySQL databases and tables. Some GUI's are even free. Anyway, I wouldn't use the MySQL commands in a DOS box. I had my share of problems with that. |
|
|
|
|
10-19-2005, 11:42 AM
|
#3 |
|
Junior Member
Join Date: Sep 2005
Posts: 8
|
Re: Importing CSV file for numeric columns
Hi,
This task is very easy with many GUI's like MySQL Turbo Manager or MySQL Manager , check the trial version. Regards, |
|
|
|
 |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Importing 3M CSV File takes over 2 hours | epromerchant | Navicat Support | 0 | 06-07-2005 04:27 PM |
| Import special characters from Mac TXT file | rmdrake | Navicat Support | 2 | 12-16-2004 09:12 AM |
| 2 Installing MySQL | Administrator | Documentation | 103 | 06-09-2004 02:53 AM |
| 1.8 MySQL Standards Compliance | Administrator | Documentation | 21 | 06-08-2004 03:18 AM |
| 1.6.4 New Features Planned for the Near Future | Administrator | Documentation | 0 | 06-08-2004 02:47 AM |
