How do I input records from a SQL query into Word Table?

Hi, thanks for your reply;
I have created a word project in VS2008, added XML Schema and can get the data into document using the XML tags.

Getting the data into the document is not the problem.  I can put the data where I need it using the XML Schema.

My problem is creating a dynamic table so that when I have added the tags (one tag for each data column entered into each cell within a row), it will then sequentially add rows to the word table as it needs to with regards to how many records are returned.

Thanks again
MM

Many thanks Peppermint;
I'll have a look now and see if it will help.

I would however like to do this without a mail merge.  The reason is that I have created a Smart Document that when after selecting a company from within the Document Action Pane and clicking on insert (a custom button) it then populates the document with information from our database.  However some of the info needs to be in a table and has multiple rows.

The main reason for doing it this way is that the document can then be used as a template throughout the company without any modification.

I'm a little surprised that there doesn't seem to be anyone who knows how to do it and I haven't found out anything through painstaking research.

I have come across documents that have this functionality and they are used within MS Accounting Pro.  Having looked at the SDK for this application I have found the relevant lines in C# that enable rows to be added to a table but the code references Small Business dll's which then seem to explicitly reference the Small Business data instance.  The code I found was:

 // Create line item 1.
IItemLine line =
invoice.CreateSalesInvoiceLine(DocumentLineType.ContractItemLineType) as
IItemLine;
line.LineItem = SBI.ItemAccounts.GetByPrimaryKey(51) as
IItemAccount;
line.Quantity = 3;

// Create line item 2.
line =
invoice.CreateSalesInvoiceLine(DocumentLineType.ContractItemLineType) as
IItemLine;
line.LineItem = SBI.ItemAccounts.GetByPrimaryKey(85) as
IItemAccount;
line.Quantity = 1;

As far as I can see the code above would enable one to create an invoice with however many items your invoice had, whether it was one, two or ten.  I maybe wrong as I am a newbie to this.

Anyhow, if any C# Super Gurus have a way in which I can do this I'd be massively grateful.
Thanks
MM

Hi Peppermint;
I've reviewed the mail merge function and although I can input my records into a table and using the <<Next Record>> it will move onto the next record, it will only do that if there is a row in the table after the next record.

My issue is that I do not want to have to manually add rows to a table so that I can view all of the records or on the other hand have to remove rows in the table if the amount of records is less than the amount of rows.

Thanks for the answer and help.
MM

Hi;
yes that is what I want to do. Do you have any ideas?
Thanks in advance
-MM

I don't think using another program is the answer, this would be a workaround and not a solution.
I need to know how to do this using the scenario above.

Thanks
MM