Data Pulling [message #349962] |
Tue, 23 September 2008 10:45  |
jagadeeshg
Messages: 14 Registered: December 2007 Location: BLR
|
Junior Member |

|
|
Hi Gurus
As a part of my job I connect to customer database and pull the data and anlayze the data (some times thousands of records) for errors. I run normally sql report and generate a flat file and convert into EXCEL with delimters.
I feel it is time consuming. I want some easy way to do it.
My requirement is as follows.
Eg:
I will be writing query like this
select * from emp;
or specifying specific columns
select empno,ename , dept from emp;
I need a sample script which convert data with delimiters and without compromising column headings width , no page breaks.
Thanks
|
|
|
|
|
Re: Data Pulling [message #350579 is a reply to message #349962] |
Thu, 25 September 2008 08:26  |
msmallya
Messages: 66 Registered: March 2008 Location: AHMEDABAD, GUJARAT
|
Member |
|
|
Hi,
You can directly pull the data in excel using DSN. excel->data->get external data->new database query->data source->cancel->cancel->sql->type your query->ok->back to excel sheet
Thanx and Regards,
MSMallya
|
|
|