bhinton

I am a real estate appraiser using FM 7.0 to create a database of sales comparables. I have exported sales data from a third party source into an exel file. I check the excel file and all the data is there. However, I am having problem importing the data into my FM program. This is what i have tried and what happens. 1. I created the FM file for the data with the appropriate matching fields. When I try to import the excel file the dialogue box does not find any source fields. 2. If I simply try to open the excel file in FM it opens it but just creates an empty database with F1, F2, F3, etc across the top, even though I specified the first row field label option. The strange thing is that the opened database says that the records are there but there is no data in the rows or colums. Any help regarding what I am doing wrong would be greatly appreciated. Thanks again. Byron.

John, Thanks for the suggestion. I am capable of saving FM records now using a PDF driver (ie. CutePDF). However, this requires me to maintain two different files of an editable document, in addtiona to saving as a PDF document. I was hoping to create one self contained file captured in the Open Office word processing file. Some of the data in the records also appears in spreadsheets in the WP file, so that is another reason I wanted to make the FM data part of a single WP file. Thanks for any suggestion or advice, Byron.

I am a commercial real estate appraiser and want to use FM 7 to maintain a database of sale transactions. Each sale is written up as a one page record. Normally, I would need to import these records (typically 4-6 in a report) to a word processing document. I utilize Open Office word processor but could export to Word document and then import that file to Open Office. I need to be able to make the FM part of the word processing document as I have to ultimately convert it to a PDF file. Any general direction on how I can pull these records into a word processing file would be greatly appreciated. Byron bhinton@ktc.com