Converting from Corel

[cleitch]

Hello,
I don't like Word but my boss is making me switch from Word Perfect to it. We create data and write out txt files. The charts move over from Corel just fine, but when I try to copy over the tables they do not work. I can't seem to figure out how to insert the data I want into a new table either. How can I insert a txt file into a table so that the table looks pretty and so that the text doesn't just come into one cell.
cleitch

 

[denisedosp]

I just did this last week. when you get external data, import, file type .txt, you should get a wizard. Corel will use commas, but if there are commas in the actual data, You will need to do a find and replace on the .txt to swap out the field deliminators to another character like ^.
If that is not the case, when the import wizard prompts for the deliminator, choose comma, if that is how it shows in the text. You may get a table with errors. This table displays the record number and field of what error was found. It is usually a data type mismatch. You can then go in and manually add just those individual cell corrections. This was quite a pain to do. You may need the following code to align left on the cells once all is said and done. I needed to do this so that labels printed correctly.
mystr: Left(trim([sStr]) & Space(20),20)
That line of code was actually gotten off another answer in this forum.
Hope this helps.
Denise