I have a database where I have web enabled the back end onto sharepoint lists to allow everyone in the office to be able to access same data and the front end client is on thier machines. I need to be able to import data into one of the tables/lists but update and append queries are not availble in the web version. I presume I can write something and perhaps put it behind a button?? I am not too good at SQL but think I probably need an update query, I have been looking for some formats but cant get anything to work.
I have a table called IMPORTS which has FirstName, Surname, Email and Telephone fields which seems to import into the database OK. I need to append/update (not sure which) these fields into Tbl_Client which has these 4 fields (among many others) called exactley the same names. Or perhaps I dont need to use IMPORT at all and can set something up to take my IMPORT excel spreadsheet and append straight to Tbl_Client ? I am good with queries nut not much good at SQL and the more I read the more confused I get, Can anyone help please?
I have a table called IMPORTS which has FirstName, Surname, Email and Telephone fields which seems to import into the database OK. I need to append/update (not sure which) these fields into Tbl_Client which has these 4 fields (among many others) called exactley the same names. Or perhaps I dont need to use IMPORT at all and can set something up to take my IMPORT excel spreadsheet and append straight to Tbl_Client ? I am good with queries nut not much good at SQL and the more I read the more confused I get, Can anyone help please?
