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 |
|
racinghart
Starting Member
49 Posts |
 Posted - 2007-04-23 : 13:41:42
|
| okay... this is a long one.we have field workers who use these nicely made excel sheets to log the times they work on a certain project for the week. generally, we have a solomon clerk take these excel sheets and enter them into solomon using the tm.pta.00 (time sheet w/amount and rate entry screen)... we are trying to make this process easier, hoping to somehow make the excel sheet take the information/data they enter and convert it into a useable csv or something that the solomon transaction import feature can read and all the user has to do is click a few command buttons and have it automate this process... does anyone here do that? get data from a nicely made excel form and have solomon automatically dump the data into a screen for input? |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-04-24 : 09:32:55
|
| without stating the obvious but "What's Solomon?"DTS can get data from csv or excel (and other sources) and transform same direct into SQL tables but not into fields on an interactive screen.A (very) rough and ready solution may be some "windows macros"....I use some scripts to automate some drudge tasks which cross interactive applications, and which are usable under supervision.There's cheap software out there which can record and replay such keystrokes... |
 |
|
|
|
|
|
using the solomon transaction import