2013 Jan 28 4:48 AM
Hi all,
By using GUI_UPLOAD i know how to upload the data into tables....
But now the query is, i had a qusetion paper, in text file, i need to upload that into the table zsr_ques.
can any one help me out in this....?
the text file name is ONGC question paper.
thanxs,
kushi
Hi all,
By using GUI_UPLOAD i know how to upload the data into tables....
But now the query is, i had a qusetion paper, in text file, i need to upload that into the table zsr_ques.
can any one help me out in this....?
the text file name is ONGC question paper.
thanxs,
kushi
2013 Jan 28 4:56 AM
hi,
Create a internal table same as zsr_ques and get the data into zsr_ques.
make your text file as same format as the internal table.
in gui upload give the file location correctly.
give file type ASC
read by line X
you get get the data into itab.
and put that into ztable.
try to SCN for more information.
hope it helps you,
Vinoth
2013 Jan 28 8:39 AM
Hi,
There are multiple ways in which your requirement can be achieved.
1. Use Document management service to store documents such as your notepad. Transaction CV01N.
2. Create a database table. Use GUI_UPLOAD to upload the internal table in ASCI format and store each line of notepad as a row in table.
3. Upload the notepad as it is to application server. transaction CG3Z. Download it when required using transaction CG3Y.
4. Compress the data of text file into raw format or hex format and then insert the same to database table. When required to read, data can be changed back to ASCI format.
Hope it helps. Thank you.
Regards,
Kartik
2013 Jan 28 3:55 PM
Thanq karthik and vinoth.,
can b the path name should be G:\ drive or not
when i am using CG3Y it is telling that target system cannot be found error....
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |