Posted - 07/09/2013 : 12:53:48
| my users create data in excel which summarize into sql-
this is the code:
insert into spipublic.serviceattendance (as_tstamp, as_lastuser, as_se_id, as_startdate, as_reason) values ('7/5/13', 'dba', '114250', '2/2/13', 'Provided') ;
the output is one column but can be several hundred rows. The "insert" is always the same, the "values" vary by row.
i can copy the data, paste it into sql and run the query. i have server permissions, my users, who are inexpirenced and dangerous, do not.
My ideal is they they can log onto to the server and then
open to the querry pane for the corrent database (call it DATA1)
paste their excel data
they can't go anywhere else, can't do anything else, just log on, paste and run.
i'm committed to having the data start as excel, and this seem like a good approach; but if you have a better or smarter way, i'm willing to try and do anything.