[MonetDB-users] CSV file to a table
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
On Tue, Nov 17, 2009 at 07:48:05AM -0800, 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?
See Section 3.1.6.4 "Copy into Table" at http://monetdb.cwi.nl/SQL/Documentation/Data-Manipulation.html 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 |
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
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
Thank you Guillaume Theoret. It worked.
Regards
Nafees Ur Rehman
________________________________
From: Guillaume Theoret
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
participants (3)
-
Guillaume Theoret -
Nafees Ur Rehman -
Stefan Manegold