Convert excel file to flat file - ?
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
Re: Convert excel file to flat file - ?
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