Update SQL Database from Access Table

[svm]

I have an SQL Database Table right now and only one field/column should be updated. The column name is TimeChecking. I need to update this column with a column in Access called Timechecking too. What do you do to update the field. Appreciate any help you can give. thanks.

 

[SQLSister]

So many possibilities. Do you want to update on a periodic basis like once a day or do you need to update every time the data changes? Do you have access to both the SQL database and the Access database on the same network?

 

[svm]

This is only one time deal. It happens when we are converting the access data to SQL and we failed to convert one column because the SQL Table wasn't defined properly. I just need to know how you are going to update the one field in SQL and get that data from access table. Thanks.