[MonetDB-users] reading from a file
![](https://secure.gravatar.com/avatar/0a6f794a386e49e7b80ed3b5c3ddf5cb.jpg?s=120&d=mm&r=g)
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
![](https://secure.gravatar.com/avatar/9b60bf117b0749e5bc94ebd0d2bc0004.jpg?s=120&d=mm&r=g)
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