You haven't said what your problem is when you import. Is the information
all going into one column? If it is, you can try Data/ Text to Columns, and
can again specify the delimiters. Is the problem when you import into
Excel, or into another application?

If into Excel, try copying your csv file and calling it txt, then opening it
with Excel will open a Wizard which gives you the opportunity to specify the
field delimiters, whether they be commas, semi-colons, or whatever.
Experiment with settings there.

Are you saying that it is separating successfully at semi-colons for some
lines but not for others? Do you have quotes enclosing the data on some
lines? Have you looked at your csv file with something like Notepad to see
what is different between the successful and unsuccessful lines?

I don't understand the part where you say "At the lower chapter the
semicolons are failure, which are the crevices symbolised." Perhaps
something has got confused in the translation from your own language?

If you are trying to export to another application, is the problem that
there are empty fields at the end of each line in the first part of your
data, but not in the later part? When I imported your example data into
Excel and saved it again as csv it included the empty fields at the end of
the later lines too.
--
David Biddulph

"Fachi" wrote in message
...
Hello everybody

I've got the following problem.
I have created a CSV-file in Excel but there is a problem when I import
it.
The problem is, that only the first 16 lines will be imported all right
and
the rest is defective.

Here is a little cutaway:

11;nominal;;4,55;;;;;;;;;
;effektive;;4,65;;;;;;;;;
10;nominal;;4,85;;;;;;;;;
;effektive;;4,97;;;;;;;;;
20119;GrKl ;;0;100;;;;;;;;
;;;41;;;;;;;;;

11;nominal;;4,65;
;effektive;;4,75;
10;nominal;;4,95;
;effektive;;5,07;
20120;GrKl ;;0;150

At the lower chapter the semicolons are failure, which are the crevices
symbolised. Why don't import it correctly?

I'm working with MS-Office 2003/XP. I import it into the Standard editor
of
WinXP Prof. If I dispose a file in the 2007 Office Beta and import it,
everything will be all right.

Can you help me?