| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fast way to insert data from database
I wrote a VB program that retrive data from SQL server to make a excel
report. The report has some static text, such as report header, report footer, etc. Besides I need to set the font size of certains columns, therefore, I cannot directly use the ADO recordset directly. To make the excel report, I need to add the data cell by cell using WorkSheet.Cells() method, it works but its performance is slow. Is there any way for me to inserting the data from database with good performace? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need really fast method to sort data for my part numbering spread | Excel Discussion (Misc queries) | |||
| Help finding a fast way to cross reference data between sheets??? | Excel Discussion (Misc queries) | |||
| database query not showing foxpro database How I import data | New Users to Excel | |||
| Bar Graph - Values from one cell, data from another FAST formating | Excel Discussion (Misc queries) | |||
| fast way to make reports from a database | Excel Programming | |||
Threaded Mode
