[MonetDB-users] reading from a file
Hi,
I am trying to insert records from a file into a table WQ using the following code. Please if someone can help me write my code correctly.
copy into WQ "C:\Document and Settings\Rehman\Desktop\wq.txt" USING DELIMITERS field_seperator ',' record_seperator '\n';
Regards Nafees Ur Rehman
On Tue, Nov 17, 2009 at 07:55:18AM -0800, Nafees Ur Rehman wrote:
Hi,
I am trying to insert records from a file into a table WQ using the following code. Please if someone can help me write my code correctly.
copy into WQ "C:\Document and Settings\Rehman\Desktop\wq.txt" USING DELIMITERS field_seperator ',' record_seperator '\n';
Try copy into WQ from 'C:\Document and Settings\Rehman\Desktop\wq.txt' USING DELIMITERS ',' , '\n';
Stefan
Regards Nafees Ur Rehman
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (2)
-
Nafees Ur Rehman
-
Stefan Manegold