If it were me, I'd probably write a small program in (perhaps) Visual Basic. Allow the program to accept command line arguments (e.g. the path to the Excel file and other arguments to influence the behavior of the program).
The program can programmatically open the Excel file, read data from the spreadsheet (similar to performing SQL select statements against a DB). The program can also make use of the Remedy API (you can find the API installer for VB on Support Web under Community downloads) to insert the data into Remedy. Inside Remedy, you can easily create workflow which performs a run process to launch your program and pass the appropriate command-line arguments. Ben -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of akRemedy Sent: Tuesday, September 19, 2006 8:21 AM To: [email protected] Subject: Want to Load Data from .XLS Can someone please help with the following; How can I call access Windows Explorer from Windows ARS User Client to 1. select an XLS file 2. open it 3. change format of three columns to show numeric data to 3 decimal places. 4. copy data from several columns in each row to an ARS 5.1.2 regular form and commit the record to Remedy. Many thanks in anticipation of your support. -- View this message in context: http://www.nabble.com/Want-to-Load-Data-from-.XLS-tf2298988.html#a6387987 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
