Hi,

Using FM9, Win XP, Excel 2003.

I need some advice regarding exporting data that will be read later by an Excel Pivot table.

I have tried many of the formats, tab, csv, mer, xls, and each one has its drawbacks :

- tab and csv are decapitated, no column headers

- mer has the headers but Excel needs a schema.ini to understand the data (mistakes numbers for text)...

- xls is working ok except that the export step halts with a dialog box when writing to the xls file and tells me something going to be truncated becaue it's too long (!!) and that's no good for a script that's destined to run unattended in the middle of the night.

So what's your favourite export filetype ?

TIA

Bobbby

I use tab.

Probably a long way around it but I created a tab file with just the headers. I added a 0 to my sort field... explained later.

I import it,show all, sort, rename the imported record removing the 0, export and then deleted the imported record.

Edited August 13, 200817 yr by Guest

Yep, Mr Cabinetman, I've heard about that one too.

I have even used it but it's so silly.

Thanks anyway.

the export step halts with a dialog box when writing to the xls file and tells me something going to be truncated becaue it's too long (!!) and that's no good for a script that's destined to run unattended in the middle of the night.

Try setting Error Capture to ON at the beginning of the script (though eliminating the warning is NOT going to solve the truncating issue...).

As far as I can see, nothing gets truncated anyway. Though I had planned to do some testing to see precisely in what circumstances the error occured.