 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / May 2007Download data from siebel to access
Hello, I am in preparation of a database and for that I need some help. The basis idea is to generate some reports based on the source data that will come from siebel (which is my companies customised software). Now I don't have any idea as to how I should link the siebel to access so that I can perform some querries and generate some reports. I tried Ashish Dev's sample database but I had some problems with it. I am novice to access and I don't know how to download the InetTransferLib, the systems give me an error message. Any help would be appreciated. Thanks, D See if Siebel can export to a text file or to Excel. Access can import either of those. PC Datasheet Providing Customers A Resource For Help With Access, Excel And Word Applications resource@pcdatasheet.com > Hello, > [quoted text clipped - 15 lines] > Thanks, > D Hi Does siebel have an ODBC driver? If so you could use it to create a Connection String. BW > Hello, > [quoted text clipped - 14 lines] > Thanks, > D Thanks both of you for replying to my message. Yes siebel is able to download the data to an excel file. But my client needs that if he enters the date for the report in access, the database should run and first go to siebel to pull an updated report and afterwards I will prepare some queries with which the data will get sorted and different reports will get prepared. I don't have an idea whether siebel has an OBDC driver where can I find it? Once again thanks for your response. I will be awaiting your reply on this, please reply as I have a call with the client. Regards, D >Hi > [quoted text clipped - 8 lines] >> Thanks, >> D Hi 1. An ODBC driver, if available, would be provided by the db's manufacturer. ODBC drivers provide a common interface enabling different applications to talk to each other. 2. Are you able to run siebel reports using Command Line commands? If so you could use VBA's Shell method to launch reports. 3. Perhaps you could persuade your client to migrate to a more 'universal' database - Access, SQL Server etc !! Good luck. BW > Thanks both of you for replying to my message. > [quoted text clipped - 24 lines] > >> Thanks, > >> D If Seibel can download data to Excel, it probably has a way to download selected data. So when the client enters the date for the report in Access, pass that date via code to Seibel so Seibel downloads only the data related to that date to a temp Excel file. Then link to the temp Excel file from Access and prepare the queries you need, sort the data and create your reports. All this can be done through VBA from the click of a button after the date is entered. PC Datasheet Providing Customers A Resource For Help With Access, Excel And Word Applications resource@pcdatasheet.com > Thanks both of you for replying to my message. > [quoted text clipped - 28 lines] >>> Thanks, >>> D Thanks a lot Steve for your reply. But as I told in my initial message that I am learning access so this is looking a bit difficult for me. It would be great If you can suggest some resources which I can go thru and learn these things. Thanks, D >If Seibel can download data to Excel, it probably has a way to download >selected data. So when the client enters the date for the report in Access, [quoted text clipped - 14 lines] >>>> Thanks, >>>> D Sorry Steve but your comment that "All this can be done through VBA from the click of a button after the date is entered" is rather simplistic! Assuming that Siebel doesn't use VBA and cannot be created as an Object, how could this be done other than through a Shell Command Line? A Command Line option is most unlikely to give the functionality need to do what is required. D - you talk about Siebel but Siebel is just a manufacturer. You need to find out what drives their applications. I know that Siebel is owned by Oracle so, perhaps, its Oracle software. If so, then there is a suitable ODBC driver (it ships as a standard with MS Windows) which would provide the interface between Access and the Siebel app. > Thanks a lot Steve for your reply. > [quoted text clipped - 23 lines] > >>>> Thanks, > >>>> D Hi D Addendum to my last message... According to the Siebel/Oracle website, Siebel apps "integrate seamlessly with MS Word, Outlook and Excel" If they integrate with Excel they will integrate with Access as its fundamentally the same application. The integration will almost certainly be through an ODBC driver which is "available from the manufacturer". I think thats your best route - goto www.siebel.com and follow the links to Support. Cheers. BW > Sorry Steve but your comment that "All this can be done through VBA from the > click of a button after the date is entered" is rather simplistic! Assuming [quoted text clipped - 35 lines] > > >>>> Thanks, > > >>>> D Thanks a lot for your help..!! >Hi D > [quoted text clipped - 18 lines] >> > >>>> Thanks, >> > >>>> D |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.