SQL to Word or formatted Excel

[Django x2]

Hi guys,

I kind of asked this the other day but wasn't fully clear in what I meant but thanks to those who did respond.

We have data in SQL. We need it to populate the same name fields in Word, OR, at least a formatted Excel spreadsheet.

I'm sure this is failry simple and could be done with a macro (as in, export SQL as CSV then run a macro)

Any ideas?

 

[Fezzer]

Use a mail merge in Word and set your database as the data source. You might have to set up an ODBC DSN to do this.

Just to let you know, your data is actually in a database (I'm presuming SQL Server). SQL is what you use to query that data and works with many different databases!!