Thank you Guillaume Theoret. It worked.



Regards
Nafees Ur Rehman



From: Guillaume Theoret <smokinn@gmail.com>
To: Communication channel for MonetDB users <monetdb-users@lists.sourceforge.net>
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
<nafees_msit@yahoo.com> 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