Ms Access help
 

MegaSack DRAW - This year's winner is user - rgwb
We will be in touch

[Closed] Ms Access help

3 Posts
4 Users
0 Reactions
105 Views
Posts: 0
Free Member
Topic starter
 

is there an easy way input something on muiltiple rows with out pressing Ctrl+C and Ctrl+V or ever Ctrl+@ (this copys what was last inputed (or somethin like that))

i cant use a update sql query cos she check each row.

so what i want to do it select a number of rows and add something to a number of columns?

hope this is understandable?


 
Posted : 22/07/2009 9:20 am
Posts: 0
Free Member
 

[i]i cant use a update sql query cos she check each row. [/i]

Explain that part a bit more.


 
Posted : 22/07/2009 9:41 am
 nbt
Posts: 12404
Full Member
 

no, it's a database not a spreadsheet. if you want to update multiple rows at once, SQL - if you want to paste, one row at a time


 
Posted : 22/07/2009 9:47 am
Posts: 0
Full Member
 

Export the table to Excel > Do the copy and paste, import back into Access.

Assuming of course there are no relational issues to deal with.


 
Posted : 22/07/2009 10:28 am