OK, I downloaded the file and changed the extension to .csv.
I then went into WordPerfect and opened my merge document and clicked on the new .csv file to import.
The document is labels, three abreast, 30 on a page.
What came up is as follows.
"PK_MONITORS","MON_MANUFA","MON_SERIAL","MON_MODEL","MON_DRIVER","MON_DEPRECATEDATE"
1,"Dell",1,"E773c","PLUG & PLAY",
2,"Dell",2,"E176FPc","PLUG & PLAY",
3,"Dell",3,"E176FPc","PLUG & PLAY",
5,"Dell",4,"E773c","PLUG & PLAY",
6,"Dell",5,"E773c","PLUG & PLAY",
7,"Dell",6,"E773c","PLUG & PLAY",
8,"Dell",7,"s720","PLUG & PLAY",
9,"Dell",8,"E176FPc","PLUG & PLAY",
10,"Dell",9,"E772p","PLUG & PLAY",
11,"Dell",10,"E773s","PLUG & PLAY",
12,"Dell",11,"E773c","PLUG & PLAY",
13,"Dell",12,"M992","RADEON 7000 (QY)",
14,"Dell",13,"1707FPt","PLUG & PLAY",
15,"VIEWSONIC",14,"VCDTS21430-2M","PLUG & PLAY",
16,"Dell",15,"E176FPc","PLUG & PLAY",
17,"Dell",16,"E772P","PLUG & PLAY",
18,"Dell",17,"2235-OON","IBM 2235 C50",04/17/08
19,"Dell",18,"E177FPc","PLUG & PLAY",
20,"Dell",19,"E176FPc","Default",
21,"Dell",20,"E773c","PLUG & PLAY",
22,"Dell",21,"E773s","PLUG & PLAY",
23,"DELL",22,"E773s","PLUG & PLAY",
24,"Dell",23,"E176FPb","PLUG & PLAY",
25,"DELL",24,"E177FPc","PLUG & PLAY",
26,"Dell",25,"E176FPc","PLUG & PLAY",
27,"Dell",26,"E177FPc","PLUG & PLAY",
28,"Dell",27,"E772P","PLUG & PLAY",04/21/08
30,"Dell",28,"E773p","PLUG & PLAY",
31,"Dell",29,"E772p","PLUG & PLAY",
32,"Dell",30,"E773p","PLUG & PLAY",
33,"Dell",31,"E773s","PLUG & PLAY",
34,"Dell",32,"E773c","PLUG & PLAY",
35,"Dell",33,"E176FPc","PLUG & PLAY",
36,"Dell",34,"E176FPc","PLUG & PLAY",
37,"Dell",35,"E176FPc","PLUG & PLAY",
38,"Gateway 2000",36,"CPD-15F23","Plug n Play",
39,"Dell",37,"E176FPf","Plug n Play",
40,"Dell",38,"E176FPf","Plug n Play",
41,"Dell",39,"E176FPc","PLUG & PLAY",
42,"Dell",40,"E176FPc","PLUG & PLAY",
43,"Dell",41,"E177FPc","PLUG & PLAY",
46,"Dell",42,,"PLUG & PLAY",
47,"Dell",43,,"PLUG & PLAY",
48,"Dell",44,"E177FP","PLUG & PLAY",
49,"Dell",45,"E177FP","PLUG & PLAY",
50,"Dell",46,"E177FP","PLUG & PLAY",
51,"Dell",47,"E772P","Plug n Play",
53,"Dell",48,"E177FPc","PLUG & PLAY",
54,"Dell",49,"E177FPc","PLUG & PLAY",
55,"Dell",50,"E177FPc","PLUG & PLAY",
56,"Dell",51,"1707FPf","Plug n Play",
57,"Dell",52,"1707FPf","Plug n Play",
58,"Dell",53,"1708FPb","Plug n Play",
59,"Dell",54,"E176FPf","Plug n Play",
60,"Dell",55,"1707FPc","Plug n Play",
61,"Dell",56,"1707FPc","Plug n Play",
62,"Dell",57,"1707FPf","Plug n Play",
63,"Dell",58,"1708FPf","Plug n Play",
64,"Dell",59,"1708FPb","Plug n Play",
65,"Dell",60,"1707FPc","Plug n Play",
66,"Dell",61,"E773c","Plug n Play",
67,"Dell",62,"1707FPc","Plug n Play",
68,"Dell",63,"1707FPc","Plug n Play",
69,"Dell",64,"1707FPc","Plug n Play",
70,"Dell",65,"1707FPc","Plug n Play",
71,"Dell",66,"1707FPc","Plug n Play",
72,"Dell",67,"1707FPc","Plug n Play",
73,"Dell",68,"1707FPc","Plug n Play",
74,"Dell",69,"1707FPc","Plug n Play",
75,"Dell",70,"1707FPc","Plug n Play",
76,"Dell",71,"1707FPc","Plug n Play",
77,"Dell",72,"1707FPc","Plug n Play",
78,"Dell",73,"1708FPf","Plug n Play",
79,"Dell",74,"1708FPf","Plug n Play",
80,"Dell",75,"1708FPt","Plug n Play",
81,"Dell",76,"1708FPt","Plug n Play",
82,"Dell",77,"1708FPf","Plug n Play",
83,"None",78,"None","None",
84,"Dell",79,"E772p","Plug n Play",
85,"Dell",80,"E773s","Plug n Play",
86,"Dell",81,"E177FP","Plug n Play",
87,"Dell",82,"E177FP","Plug n Play",
88,"Dell",83,"E177FP","Plug n Play",
89,"Dell",84,"E177FPc","Plug n Play",
90,"Dell",85,"E773c","Plug n Play",
91,"Dell",86,"M992","Plug n Play",
92,"Dell",87,"1708FPt","Plug n Play",
93,"Compaq",88,"PC1127","Plug n Play",
94,"IBM",89,"2235-00N","Plug n Play",08/08/08
95,"Gateway",90,"CPD-17F13","Plug n Play",
In addition, since you had asked for other files:
I opened a .dbf (dbase) file in WordPerfect. It gives you the option for TEXT or MERGE DATA:
When I open in MERGE DATA, I get a buch of ENDFIELD tags. When I try to copy the data here, the ENDFILE tags disappear.
So. I am trying to post, now, using the TEXT feature, which reproduces, as follows:
TITLE FIRST NAME POSITION BODY ADDRESS ADDRESS1 CITYSTATEZIPCOUNTRYW_PHONEW2_PHONEH_PHONECODESPECIALHQ_MEMO
Miss Kathy Rush Reporter NBC Radio 800-669-6789
Mr. David Molpus Reporter National Public Radio 919-966-6191 01/25/94:
Mr. Lenny Simpson Reporter USA Radio 800-877-8721 800-992-8721
Mr. Bob McCall Stringer Bavarian TV 404-876-6100 09/05/96
Is any of this helpful? If so, what next!
Thanks.
----
Here is the thread from the WordPerfect site:
http://officecommunity.com/forums/1646/ ... .aspx#1646
--
I had been using dBase (DOS-database-program, obsolete for many years, however) for some time, with excellent results, exporting into WordPerfect. Now that I have switched to Vista 64-bit (Ultimate), however, 16-bit dBase is no longer supported. So, the question was how to find a database program that would work with WordPerfect? I checked on OpenOffice (Sun-Microsystems), which has a program called "Base." Their forum suggested that I transfer my dBase file to a spreadsheet in OpenOffice "Calc" and save it as a .csv file, then proceed to use it with WordPerfect. I tried doing that, but could only get so far.
By the way, OpenOffice has a conversion feature to Microsoft Word, but nothing apparently to WordPerfect.
In my WordPerfect documents, I have the MERGE-FIELDS already set up. Then, when I clicked on COVERT in WordPerfect, and access my newly-created .cvs file, the error-message, "Unknown Format" crops up. My previous exported files had a .dta or .dat extension.
So, is there any way to use OpenOffice with WordPerfect, for merge-database purposes? Or, would there be some other work-around, configuration or other program that might work? I would like to keep using WordPerfect, if possible, but do need a way to merge names, addresses, etc. into documents. Any help appreciated. Thanks.
---
You might be able to open the dBASE file directly in WordPerfect ....
Insert > Spreadsheet/Database > Import
Select Data type as "dBASE", and Import As "Merge Data File"
Select the dBASE file
Click "OK"
Now you'll have your DAT file.
If it doesn't work, you could try importing the dBASE file into Quattro Pro, or failing that -- bring the CSV into Quattro Pro and save it as a QPW. Then in Step 2, select "Spreadsheet" instead of "dBASE".
Cheers,
Heather
---
Hi, Heather, many thanks. I tried step one and it worked. I was able to import the dBase file into my WP form -- address-labels, in this case. Good start?
However, that is only a fraction of the problem!. I still need a program to substitute for dBase. dBase is a 16-bit DOS program, which does not work on Vista 64-bit. I am using Vista 64-bit and wish to retire my older XP computer, entirely, which ran both dBase and WP just fine. In other words, I will not have the capability of using dBase anymore and data-entry and processing (for mailing) makes up quite a bit of what we do.
dBase allows the user to manipulate the data, sort files, append, keep records, manage fields, all sorts of things. So, just importing dBase will not solve the problem.
I recall that WP had a dababase program, several editions ago, but apparently abandoned it. I think it was called Paradox? Anyhow, I was trying to find a database program -- I located OpenOffice by Sun -- which could allow me to keep track of data and, then, import into WordPerfect.
OpenOffice apparently is designed to work with Microsoft Word, Office, etc., but I -- and others -- are stumped about getting it to work in WP. Any ideas?
Here is a thread on OpenOffice, as well.
http://user.services.openoffice.org/en/ ... 13&t=14622