I wasn't able to figure out the vocab to search for this on usenet.
I'm sure it's an easy solution, but I have no experience with SQL
Server:
Situation:
tbl_CompanyData
is a 1735 x 20 table with a CompanyID key in the first column
tbl_MergedCompanyData
is a 1735 x 20 table imported from Excel. We found it much easier to
enter data into an Excel file.
Problem:
Keep the CompanyID field in tbl_CompanyData, but replace all the other
19 rows with data from tbl_MergedCompanyData, which contains all the
tbl_CompanyData PLUS new data that users filled in. At present, the
rows don't match up, but I suppose I could pre-sort the tables.
Preferrably, any solution would be smart enough to find CompanyID N in
tbl_MergedCompanyData and replace the data in the fifth column in
tbl_CompanyData where CompanyID is N with data from the fifth column
in tbl_MergedCompanyData.
Any thoughts would be appreciated. Please let me know if I can
clarify my problem.
Thank you,
Ryan