Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Tables storing results of Stored Procedure
Dear all,
I need to populate the result of a stored procedure from SQL Server into a Word 2000 document and present the result as a table. The result of the stored procedure can be up to thouands of rows, which construct a table of over hundreds of pages. I use ADO to run the stored procedure and populate the result as a delimited text Then I use ConvertToTable to create the table from the delimited text. This works fine. However, I need to apply differet format to each columns of the table (alignment, fonts...etc.). Since, in Word 2000, Table object does not support the Style property, it takes long time to apply each style separately. Is there a more efficient way? The result of the stored procedure contains carriage return. Therefore I need to convert the carriage return to another character before running ConvertToTable and then use Find.Execute to replace them back to carriage return afterwards. Is there a more efficient way? Another question is that will it be faster if I use Database Fields instead of using ADO to get the result? Thank you very much. Edward Li |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When joining tables, table sections shift left or right. | Tables | |||
Is there a way to "join" tables in Word 2003? | Tables |