Hi, my question isIn a screen i have 1 datagrid with the data i have to do 2 things1)Save the data in the grid to the CSV format2)Load the Saved CSV format file into the grid as well as into the Sql Server database table at a time..

Interview Candidate
Aug 5th, 2006
6
1557

Showing Answers 1 - 6 of 6 Answers

gtomar
Profile Answers by gtomar

Jul 28th, 2008

Hi,

If you are using Toad then you need to follow up the steps given below:-

1. Right click on the left top of the grid then Save datagrid in .xls format.

2. Open .xls file and again save it in .csv format by selecting save as type CSV(Comma Delimited).

3. Now open .csv file in textpad and save it as file format UNIX. It just asked you to replace the same .csv file with unix format .csv file.click yes to move ahead.

4. Login to Toad. Go through
DBA
< data import/export
< SQL loader Wizard
<Choose Build Control file (Browse .csv from the saved location) and add it.
< Add tables from the database
< Finish.

5. It will load required row in the table.

Thanks,
Gunjan

gtomar
Profile Answers by gtomar

Jul 28th, 2008

Hi,

you can do it directly also by saving datagrid as sql loader file .
and then login to toad and choose csv file directly to load data into table.

Thanks,
Gunjan