Paste from Excel

[gulhaugen]

We are using version 7.0.2

When copying from excel into a table (select t.*,t.rowid from blah t where 1=2) the first column from excel is missing.

Morten

 

[Marco Kalter]

Works fine for me. Note that you need to select a cell (or range of cells) before you can paste the data.

 

[canadj]

i bet it's the rownum, if you have a counter column in your grid then you'll need to click and drag it to the far right side of the grid or else it'll try to paste your first column into this field.

I beleive you can remove the rownum through preferences.

 

[hbar]

I always copy one extra blank column on the left hand side of my data, then it pastes in fine (props to canadj).