Fast way to insert data from database

  • Thread starter Thread starter gh
  • Start date Start date
G

gh

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?
 
Perhaps have an intermediate stage in the process and get the data usin
ODBC in a new worksheet then pull it across into your target workshee
from there?

Dunca
 
Put the raw data in using ADO (good performance) then open it and do
the formatting etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unobtrusive Place To Put Report TItle and a List? 5
VBA - retrieve data on last create named range from previous inserted named range 0
inserting from database 1
Cannot insert the sheets in to the destination workbook 1
Non-macro method (like conditional formatting) to insert text in cell? 7
Can't create a report from my query in Access 1
Efficient Excel to Access uploads 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top