Hi, Since you have it on a file (1 line per tuple I guess) you can run the following sql command: COPY #num RECORDS into table_name from '/filepath/test.txt' delimiters '|', '\n'; where #num= the number of rows you will load, and table_name the name of the table that you have already defined to store the data, with an sql command like: create table table_name (id int, name varchar, address varchar); On Sat, Apr 19, 2008 at 1:04 PM, Martin Kersten wrote:

ks038c wrote:

...

How can I load large dump data into MonetDB

I mean...

I have "test.txt" file with "csv" format like.

00001|"name1"|"address1" 00002|"name2"|"address2" .....

and want to load this LARGE data into my table

TEST( ID NUMERIC(5), NAME VARCHAR(10), ADDR VARCHAR(20) )

I found word "tablet.load" or "tablet.SQLload" in m5manual but don't know whether it is the one I need or not and don't know how to use it.

I beg yout answer...

http://monetdb.cwi.nl/projects/monetdb/MonetDB/Version4/Documentation/Module...

------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao... _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users