[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
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |
participants (2)
-
Nafees Ur Rehman
-
Stefan Manegold