Excel column order

[paul_rodgers]

I select a bunch of columns from an object, fech the data just fine.
But I want to re-order the columns in the spreadsheet, it will not let me insert a new column, and cut-paste an existing column into it.

If I come out of edit-mode, create a new column, give it the new column-header and put data into it, then delete the old column (the one with that header) now when I try to commit I get a message that its not a double-precision number.

Its as though the update mapping to the data source is strictly by column number, not by the header

Am I just missing something?

[paul_rodgers]

found my own answer, have to write the sql query rather than use cut-paste to move excel columns around