Software

Ask something
Discussion Locked

I need a CSV file

0 helpful
5 replies

by navjun

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have an excell file and i need to make a CSV format out of it:

The CSV file should look like this:
"12";"1555";"10000";;"101.00";"2002-04-22 17:17:01";NULL;NULL;"1.00";"1";"1";"1";"1"
Each value should be enclosed in a unique character (e.g. single or double quote: ' or ")
Fields must be separated by a unique character (e.g. comma or semicolon)
Lines must be terminated with an enter or newline character.
Fields with no value must stay empty: eg ..."01";;"text";"anothertext";;"1"... orthey can be represented by NULL
Please notice: 0 (zero) is not an empty value!
please help me out
thank you

5 replies

by ptaylor

An easy way I have found to create a CSV formatted file is to import into a table in Access. After importing, export the same table and choose Text Files for "Save as Type". When you hit the save button, it will allow you to choose your delimiter for separation of values.
Hope this helps.

This discussion is closed to new replies.