how to get a selected column from (;)delimiter report to an excel fil

[092167]

hello guys!

I was instructed by my boss to open a delimiter format report (from ICMS)in ultraedit32. the i went to 'column' and convert the file with fixed column (text document). i need to get some selected columns for my excel report but i dont know what to do. i don't have background with foxbase, he told me, i can extract the couln through this.
pls help

 

[DSummZZZ]

The easiest way would probably be to import it into Excel and delete the columns you don't need.
But if this is a more-than-once routine, create a table with fields the width they need to be for the import file:
CREATE impfile

Make your fields the necessary width, decimals, etc.
You can then append the records from the text file:

APPEND FROM MyTextFile.TXT SDF

Then copy to your Excel file:
COPY FIELDS Field1, Field2, .... TO xlFile TYPE XLS
Where Field1 and Field2 are the actual names of the fields.

The next time you append a file, you will open the same table and append:

USE impfile EXCLUSIVE
ZAP
APPEND FROM MyTextFile.TXT SDF
COPY FIELDS Field1, Field2, .... TO xlFile TYPE XLS


-Dave S.-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm