hi,
A comma delimited file is a database exported into a format where each record is a single line and each field in the record is indicated by a comma. Where necessary (e.g., if the field has a comma in it) the field will also be quoted. If you have Excel, use the import feature of Excel to import the file. Specify comma delimited format as the import format. Then export to whatever format you require for the data.
You can also usually import this format directly into most any database program or spreadsheet program as well. This file type is often associated with Microsoft Excel as this is one of the standard ways to transfer data into and out of a spreadsheet
CSV stands for Comma Separated Values, sometimes also called Comma Delimited. A CSV file is a specially formatted plain text file which stores spreadsheet or basic database-style information in a very simple format, with one record on each line, and each field within that record separated by a comma. It's important that the individual "records" within a CSV file NOT contain commas, as this may break the simple formatting when using the file in another application.
CSV files are often used as a simple way to transfer a large volume of spreadsheet or database information between programs, without worring about special file types. For example, transferring a home-made address book from Excel into a database program such as Filemaker Pro could be done by exporting the file as a CSV from Excel, then importing that CSV into Filemaker.
Creating a CSV file from spreadsheet data is very simple to do using Microsoft Excel.
Open your spreadsheet document and go to the File pull-down menu, then choose Save As....
Change the "Save as type" or "Format" field to read: "CSV (Comma delimited)".
Enter a name for the document and click Save.
To check the validity of your CSV file, open the new file from a plain-text reading program such as Notepad or TextEdit. Check to make sure there are no extra commas, other than between fields. Depending on what program you're going to use the CSV file with, you may need to also remove any extra quotation marks or other formatting which Excel may have inserted.
Hope this helps, Do reward.
Edited by: Runal Singh on Mar 10, 2008 11:25 AM
