Updating a field in access with a range of cells

[ASHRAF_AL_ANI]

Dear All
I want to update a column in an access table with a range of cells values without effecting other columns in that table
please how can I do that using VBA

thanks

 

[Joe4]

Can you explain in more detail?
Maybe, walk us through an example of exactly what it is you are trying to do?

 

[ASHRAF_AL_ANI]

Thanks for replay
what I am trying to do
I have a database called compare.accdb it has a table called main
the main table has 3 columns id,date,info all columns have information except info
I have an excel sheet called info

I want to updated main table just column info with the information that I have in my excel sheet starting from c1 till c100

I hope I explained my problem good

many thanks

 

[Joe4]

You can link your Excel table into Access.
Then, you can link your Excel table to the Access table, providing that you have some common field to join on.
You can then create an Update Query to update the Info field (from the Excel file to the Access table).

 

[ASHRAF_AL_ANI]

thanks for replay but cant I do it with a VBA code just inserting these cells in my access table field? I mean by inserting c40 in record 40 from table INFO and c60 to record 60 and so on?
many thanks

 

[Joe4]

thanks for replay but cant I do it with a <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-top-style: initial; border-right-style: initial; border-bottom-style: dotted; border-left-style: initial; border-top-color: initial; border-right-color: initial; border-bottom-color: rgb(0, 0, 0); border-left-color: initial; border-image: initial; cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> code just inserting these cells in my access table field? I mean by inserting c40 in record 40 from table INFO and c60 to record 60 and so on?

I do not think that is an easy thing. I would not know how to do that. You really cannot link just certain Excel cells to certain record fields in an Access table. Either the whole table is linked or it isn't. In theory, you probably can come up with VBA code to do just about whatever you want, but it could be a bit complex.

I would recommend re-thinking your process.

 

[ASHRAF_AL_ANI]

thanks a lot