PASTE few cells (at once) into table (datasheet view)

[kszacki]

Hi
After few months, again... I need YOUR help.


While in a table (datasheet view), I want to paste for ex. 4 cells, at once, (in one row of course) copied from Excel.

Most common question -> HOW CAN I DO THAT?


Charles

 

[mikehoot]

Funny one this, but give it a go.

Select and copy your cells in excel. Bear in mind that if you have a auto-number primary key that data in the first cell will be replaced by this.

Select the new record line (*) in your datasheet CTRL + V. This will paste the required cells.

This process will also work with multiple rows.

:-9

 

[kszacki]

:~/
I feel stupid

I wrote my post, just after my ... hmm how is it in english...
injection that makes You flu resistant
and I was little X-)

sorry
thx for not laughing at me ...

Charles