Copy to ACCESS in datasheet view

[johnseito]

Hi All,


In share point, you could copy excel data into share point's access datasheet view !

Could we do this in ACCESS, copy data from either another access or another excel to a separate ACCESS datasheet view ?

Or we have to import it all the time ?

I think copying it is much quicker than if we were to import it.




Thanks !!! :-)

[lfpm062010]

The short answer is "Yes". You can copy data from another Access database or Excel, or other sources.

Copy and paste data does not mean it will be quicker. Sometimes, it will be slower with large amount of data or copy it from another external database (like ORACLE, SQL SERVER, etc).

If you can give example of what you tried and did not work, maybe we can show you how or different way of doing it.

[johnseito]

If you can give example of what you tried and did not work, maybe we can show you how or different way of doing it.

Ok, what I am trying to do is, I opened an access database, click on a table or a query to open in datasheet view.
All I am doing is I am selecting a column, and ctrl C to copy and then go to another database into another table or query and click paste
(where I want to put it).

I do this in excel to, so in excel I have data, I copy what I need, and go to access database, a query or table and in datasheet view, I go to
where I want to put the data, and click paste.

Both of these method doesn't work. However it works in share point when I copy excel data into share point datasheet view (which is similar to access's datasheet view).

[lfpm062010]

To copy the column of information is not the problem.
The problem is when you paste it to another Access table (does not matter if they are the same access database or not).
If you paste it into a empty table, highlight the column that you want to paste then it should work. If you are paste into a table that already have data, then you have to highlight the exact rows on the table to be able to paste it. That is what I remembered.

There might be other ways.

[johnseito]

Thank you !! I noticed copy is not a sure thing that works all the time or is convenient, it needs to fiddle with almost.