>What I was trying to say was that an append could be utilized directly from the
>table that was created from the spreadsheet, rather than dumping the resultset into an array, thus eliminating one step.
>
>Bill
Ok, I got it know.
Maybe what you are looking for is the APPEND FROM command.
APPEND FROM FileName | ?
[FIELDS FieldList]
[FOR lExpression]
[[TYPE] [DELIMITED [WITH Delimiter | WITH BLANK | WITH TAB
| WITH CHARACTER Delimiter]
| DIF | FW2 | MOD | PDOX | RPD | SDF | SYLK
| WK1 | WK3 | WKS | WR1 | WRK | XLS | XL5]]
[AS nCodePage]
As you see lots of formats you can import from. Unless you have another kind of exotic format.
With this command you only have to take for dates, these can cause some problems. In the way that in excel al columns need to have the date format in order to be correctly imported. I know that you really have to take care with dates, but I'm not really sure what was the problem.