MySQL Forums :: PHP :: Importing part of a .csv file

Advanced Search

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


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:

Thanks in advance

Options: ReplyQuote

Subject Written By Posted
Importing part of a .csv file Max v Heiningen 11/14/2012 08:08AM
Re: Importing part of a .csv file Barry Galbraith 11/14/2012 02:47PM

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.