Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 5th, 2005, 12:32 AM
Registered User
 
Join Date: Jul 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Optimized method to post data & format into Excel

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.

 
Old July 14th, 2005, 09:23 AM
Authorized User
 
Join Date: Aug 2004
Posts: 54
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.





Similar Threads
Thread Thread Starter Forum Replies Last Post
post method franta1346 Reporting Services 0 July 22nd, 2007 11:08 PM
POST method not working ganesh15 Beginning PHP 2 February 18th, 2006 08:35 AM
Post Method Error spitz Classic ASP Databases 2 June 10th, 2005 04:31 AM
about post and get method csc820203 HTML Code Clinic 1 August 2nd, 2004 01:13 PM
Post Method? zhenwe1 Servlets 0 January 25th, 2004 01:17 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.