MySQL Forums
Forum List  »  PHP

Importing part of a .csv file
Posted by: Max v Heiningen
Date: November 14, 2012 08:08AM

Hi,

I have a problem, I'm trying to find out if it's possible to import only part of a .csv file into mySQL without editing it myself.

A small example, lets say I have an calc document with 7 different rows:



I've converted the calc document to an .csv file however I want only the first 4 Rows (Title 1 to Title 4) in my database.



Is it possible to choose which rows you want to import into the database through a wizard because I dont want to do everything by hand since this is a small example and I need to do this with 3 huge documents.

Now I have to keep deleting the top row each time shown in this video:
http://www.youtube.com/watch?gl=NL&hl=nl&v=diEwQk4uY14
(10:12)

Thanks in advance

Options: ReplyQuote


Subject
Written By
Posted
Importing part of a .csv file
November 14, 2012 08:08AM


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.