Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
export data from discoverer to excel using vba
Hi experts out there,
I would like to export data from an external database query into excel. I have been reading through different forums and posts, but I stll don't really understand things. Here is my problem:
I have an external database query program called discoverer. It uses SQL statements to query an oracle database. However I do not know anything about SQL I can use this program because it is like a user friendly interface for non programmers.
What I have so far in excel vba is the following:
Set DiscoApp = CreateObject("Discoverer.Application")
DiscoApp.Visible = True
Set Workbook = DiscoApp.documents.Open("X:credepDTADISCOITEM & ITEM COST REPORTSJME_itemcost_testv1.DIS")
Set Sheet = Workbook.Sheets("Crosstab_IC")
This code perfectly starts the external application called discoverer, runs the query and returns the data. BUT of course this data is still in the external application. How can I now get the data from this query directly imported in excel? Discoverer even has a button to import data in excel so the program must know the command somehow. Why is it than so complicated? I appreciate all help I can get. Please be easy on me, I'm just a beginner and experimenting with VBA
0 · ·