Re: [MonetDB-users] CSV file to a table

17 Nov 2009

      Thank you Guillaume Theoret. It worked.

Regards
Nafees Ur Rehman

________________________________
From: Guillaume Theoret 
To: Communication channel for MonetDB users 
Sent: Tue, November 17, 2009 5:06:12 PM
Subject: Re: [MonetDB-users] CSV file to a table

Try this:

COPY [num_records] RECORDS INTO [schema_name].[table_name] FROM
'[full_path_to].csv' using delimiters ',','\n';

On Tue, Nov 17, 2009 at 10:48 AM, Nafees Ur Rehman
 wrote:
...
Hi,
 I am trying to read a CSV file content to a table. But I think Im making
mistake in the syntax somehow. Can any one please guide me a little?
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
------------------------------------------------------------------------------
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