Transfer data from excelsheet to access table

Hi guys

In my access table there are also 90 columns but when the user enter the data in the access table then it gets entered in about 20 columns and rest of them are left blank and then the data is exported from access to excel using vba and then sent to an email address using vba.

And now when the user receives the email then in the excelsheet some columns are empty to let the user enter some more information in the corresponding records. When the information is being entered and sent back to the original sender manually.

Now from that excelsheet, I want some facility to transfer the new information of those records back to access table. Like it will transfer the extra added information in some columns which were originally empty back to the access table whose ID matches with the ID in excelsheet.(ID is the unique field)

Can anyone please guide me how to do that.

Thanks

hi, aman1234, may be info on this link will help you: http://office.microsoft.com/en-us/ac...001095095.aspx

Still couldn't figure out the problem. As everytime the excelsheet would be different.

In actual when the email is being sent to the client automatically from access database then before it asks number of records to be sent and then the email is sent with an excel attachment.
Now the client is in another company and he receives the email, read the excelsheet records and add morev information in empty columns in the excelsheet and send it back to the original sender.

Now they want me to input the extra details of those records back to the access database.

So everytime a different excelsheet is sent and marked as 'sent' for those records in access database.

When they recive the excelsheet back then the corresponding records should be marked as received automatically.

But how?

Thanks in advance for any help.