Convert excel file to flat file - ?

[ailing]

Hello to ALL,

Does anyone know how to convert excel file to flat file?
This flat file will later be uploaded to the server (Solaris).
At the server-end, a method will be executed to read data from this flat file
& update to database (oracle).
Please advice me on how i can convert excel file to flat file & later read from it to update the database.

Thanks
Ailing.L

[Axel Goldbach]

Hi,

I think you mean ASCII file if you say flat file. The easiest way is File/Save As and the file type could be CSV or Text.
CSV is
1;"Hello;World";3
4;Yeah!;6

Text is
1 "Hello;World" 3
4 Yeah! 6
(there are TABs between the characters)

Hope this helps
Axel