How to Import a .CSV file.
| User, date | Message |
|---|---|
|
Written by dougins99
5 years ago Category: Import/Export 3 posts since Mon, 14 Apr 08 |
I have tried to import a .CSV file with no luck. The field names are the same. Anyone have idea? |
|
Written by kalvaro
5 years ago 442 posts since Thu, 29 Nov 07 |
In what way did you have no luck? If all the information you give is it doesn't work we can't tell you more than there must be something wrong :wink: |
|
Written by dhivya
1 year ago 1 posts since Tue, 10 Jan 12 |
hi all, when i tried to import .csv file into database, i'm getting no errors or no successful message. i cant find what is happening. after selecting filename , what do i need to give in terminated by, enclosed by, escaped by fields.. and also in line fields.. any idea? |
|
Written by ansgar
1 year ago 3977 posts since Fri, 07 Apr 06 |
You have to specify the control characters which were used to create the CSV file. For example ";" as field separator, and "\r\n" as line end. But I can't tell you the right values - you will have to look into your CSV file in order to find the right chars. |
|
Please login to leave a reply, or register at first. |