Does anyone know about a method to write data onto excel from a DB Source? Also one should be able to apply formatting to the data, the format of the same already found in the excel.
In other words it is like punching data on to a preformatted excel sheet. Currently we have been doing it by consolidating the data as well as the format on to a text file and then reading the text file and putting data cell by cell and applying format cell by cell which takes a long time say 10000 X 20 matrix takes around 10 minutes.

You do not say exactly where your data is coming from. However your general method is a bit questionable.

One way of importing data is to use the Menu Data/Get External data.

I more often use a method similar to yours, except that I get text file output from our Corporate database and just import it into Excel using File/Open. It is best not to get too fancy at this stage because the more you try to do here the more likely is data corruption.

Actually your other idea is not a bad one. It would be very easy to copy the text file data and Edit/Paste Special/Values into a preformatted sheet. I do not generally have to bother with this because I have to analyse the data, and that is what people tend to see.

Hope this helps



-----------------------
Regards BrianB
Most problems occur from starting at the wrong place.
Use a cup of coffee to make Windows run faster.
It is easy until you know how.