Database to Word

May 11, 2011 at 07:53:56
Specs: XP, 3.2 / 6
Newbie here, looking to create first database for my business. Before I start, I'd appreciate any advice you have about extracting the output to Word 2007. I'll likely be using something user friendly, like Filemaker Pro 11.

Example: Database filled with specifics about a piece of property that differ from property to property (i.e., address/street, county, date of sale, topography, river frontage, etc.). I want to be able to search for sales in XYZ County that occurred between 1/1/2010 and 1/1/2011, then output the details to both Word [for reporting purposes] and Excel [for charting purposes].

From what little I know, thus far, it seems like exporting the search results to a csv file is the appropriate route, but I need to know how to get the individual fields/data into a preformatted document template (or active word document that I'm typing in). Any ideas/suggestions/softwares to make that happen [as effortlessly as possible]?

See More: Database to Word

May 11, 2011 at 08:08:40
Your database application should be able to create reports and charts. No need to export / import

Report •

May 12, 2011 at 15:18:24
Thanks - Its not a matter of viewing the charts in one place or another, I physically need to produce a Word document containing fields from data in the database. I also need to be able to manipulate the data in Excel.

For example, if you had a database filled with all of the houses that sold in your neighborhood - some with carports, some without, some with basements, some without, some with 2,800 SF, some with 2,500 SF.... If you were to compare your house, at 2,500 SF, with a carport and with a basement, you'd want to filter for sales that fit those criteria, then bring them into Excel to say "Ok, these five houses sold... but this one sold a year ago, these two sold six months ago, and these two sold a week ago. I need to correlate the otherwise-similar data based on date of sale, because prices go up and down over time."

The end product is a word document with 1) the raw data, as filtered down to applicable house sales; 2) price-adjusted data in a pre-formatted Excel spreadsheet; 3) the appropriate value, following adjustment to the price for date of sale. Again, the end product [the work product...] is a word document, not the ability to see raw data.

Report •
Related Solutions

Ask Question