Importing part of a .csv file
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
Subject
Written By
Posted
Importing part of a .csv file
November 14, 2012 08:08AM
November 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.