Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nt-pilot
Starting Member
2 Posts |
 Posted - 2006-01-27 : 12:35:32
|
| Is there a simple way to UPDATE a SQL table from a seperate MS Access file based on a sigle WHERE clause. I have a 'portable' MS Access file that was origionally uploaded and imported into a SQL table. However, the Access file gets updated offsite and needs to be uploaded/imported back into the master SQL table as an update based on one of the fields.How can I do an UPDATE query with this Access file? Thanks for any advice |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-01-27 : 13:33:25
|
| Welcome to SQLTeamDo you mean use the access file as a frontend to SQL server backend ? |
 |
|
|
nt-pilot
Starting Member
2 Posts |
Posted - 2006-01-30 : 08:10:23
|
| Not really.We have a product serial number database (now a SQL table used in support web app) that was origionally the Access file. This SQL table holds all product info based on serial number. The Access file is still used in manufacturing facilities (on in UK, one in China) to capture product info during build (MAC Address, build date etc). This file needs to be 'merged' with the online SQL table from both manufacturing facilities. The best way I think to do this is use an 'UPDATE' query to update existing serial numbers in the SQL table with changes that have occured during manufacture in the access file. Another option may be to APPEND the new access file to the existing table, only problem is that existing Access file contains all previous serial numbers and history, which will create duplicate entries.Thanks for your help. |
|
|
|
|
|
|
Import and UPDATE from MS Access file