Creating a .frm file in Quattro Pro to merge with a WP .dat file - General Feedback - WordPerfect Office - OfficeCommunity.com

Creating a .frm file in Quattro Pro to merge with a WP .dat file

Is there any way to create a .frm file in a QP spreadsheet and have it merge with a .dat file already created in WP?

I am using WP X5

14 Replies

  • That sounds backwards. I did not see a way to do this. Usually the frm is in WP and the data, if not from WP, then a source like QP, Excel, a database, etc.

    What is your desired result? To get your WP data into QP? Or is there some other purpose?

    Just open the WP dat file with QP and see if  this is useful.

  • In reply to tlnett:

    It is backwards and it is what I need. I know you can perform this merge with Word and Excel and I'm surprised you can't with WP and QP. I have a WP form file (that we use to create a set of documents for a sales transaction) in WP that was created with a merge. I would like to take the .dat file from that particular transaction and merge it with a QP spreadsheet which has much of the same information. I currently have a table in that particular file to create a closing statement, but the formulas don't always work properly when inserted and deleting rows and I don't like to take the chance of numbers being incorrect.
  • In reply to Marsha V:

    I had edited my previous post to add "Just open the WP dat file with QP and see if this is useful." Perhaps you did not see that. Just open the WP .dat file in a new blank QP spreadsheet. Then you can see if the data could be easily pasted into your document. That way there is less risk of trashing your existing.... Perhaps someone will be along with better information.
  • In reply to tlnett:

    I just tried your suggestion and it inserted all of my .dat file info into the first cell only LOL
  • In reply to Marsha V:

    I have a test data file "test.dat" that I had created for other purposes. It has 5 records of 3 fields each with the ENDFIELD and ENDRECORD codes. It opens vertically with the FIELDNAMES in cell A1, field 1 of record 1 in Cell A2, field 2 of record 1 in Cell A3, and so on. ENDRECORDs are blank cells.

    How is your data file structured? Is it a true WordPerfect datafile that is made for merges?
  • In reply to tlnett:

    My .dat file is a standard .dat file and I just tried opening another file and it did open like yours did but now what? You can't save it as a .dat file in QP and that still doesn't address the issue of how to save a QP document as a .frm file. I'm trying to figure something out with the "insert / external data" or the import function. I would really like to get this to work!
  • In reply to Marsha V:

    You are way above my pay grade. If you do not get a response here, you could try posting at WPUniverse.com in the Other WordPerfect Office Programs forum. There are some very knowledgeable people there. Good luck.
  • In reply to tlnett:

    Thank you - I believe someone from Corel support is actually looking into it as well. I'll let you know if they ever get back to me.
  • In reply to Marsha V:

    Open your data file in QP, or paste the data into QP (try both). Then, in QP, select your data and play around with Tools - Data Tools - Quick Columns.

    You will likely be able to convert your data into a usable spreadsheet in QP. Be sure to look at Settings, in the Quick Columns Expert dialog box.

    Ron S.

  • In reply to frisbee:

    One way to do this is to create a new FRM file in WordPerfect consisting of a table into which the data can merge; merge the DAT file into it to generate a table of all data; select the entire table and copy; open QP; and paste.

    Another way is to save the data in a text file with delimiters to replace the endfield and endrecord codes. Then, that text file can be imported and parsed into QP.

    There ought to be an immediate, direct way to convert between DAT and QPW formats, but at present, there does not appear to be one.

    Charlie
  • In reply to Charles Cork:

    Charlie - your first suggestion does not work as it does not carry over the formulas. I do not understand your second suggestion - the terminology is beyond me... sorry. I let Corel know that they should explore this because it is possible to perform this function with Word and Excel.
  • In reply to Marsha V:

    As to the first suggestion, the subject is still how to get data from a WordPerfect DAT file into a Quattro Pro spreadsheet, right? Do you really have formulas in your WordPerfect DAT file? If not, what formulas are failing to "carry over" from what file to what other file?

    The second method is a bit more complex. When I get some time, I'll work on fleshing out the concepts.

    Charlie
  • In reply to Charles Cork:

    I have a WP table with formulas. I merged that .frm file with the .dat file and then copied and pasted into a QP spreadsheet and the formulas from the WP table did not carry over to QP. Also, the columns/rows were a mess. I appreciate any help I can get. The bottom line is, I have an entire real estate file set up for merge in WP which is mostly word processed documents and one table/spreadsheet (a closing statement). I've had issues in the past with the WP table and formulas not working properly, especially when inserting/deleting rows, etc. In that a .dat file is already set up for that real estate package, it would be ideal if I could simply merge the WP .dat file with a QP spreadsheet for my closing statement.
  • In reply to Marsha V:

    I can't visualize what you're trying to do. If you can post the FRM and DAT files (and QPW file if it is involved), perhaps with sample dummy data rather than actual data, I or someone else may be able to figure out what you're trying to do and suggest a good way to do it.

    Charlie