[progress Communities] [progress Openedge Abl] Forum Post: Re: Extent Fields In Excel Via Odbc

  • Thread starter Thread starter Steve Moore
  • Start date Start date
Status
Not open for further replies.
S

Steve Moore

Guest
Does the following - works with Excel 2013 and OpenEdge 11.6 - solve the problem? 1) In Excel select "From Microsoft Query" from the "Other Sources" drop-down (Get External Data) in the "Data" tab. 2) Select the OpenEdge database. 3) Add the fields including the extent field. 4) Confirm the various dialogs and for the "Query Wizard - Finish" dialog select "View data or edit query in Microsoft Query" then the Finish button. 5) From the new "Microsoft Query" select "View->SQL...". 6) Edit the SQL code replacing the extent field with the extent number(s). Instead of Salesrep_0.MonthQuota you have Salesrep_0.MonthQuota[3], Salesrep_0.MonthQuota[7] etc.. 7) Press OK. A message will appear saying "SQL Query can't be represented graphically. Continue anyway?", OK this. 8) File->Return Data to Microsoft Excel and only extent fields data should be in the columns.

Continue reading...
 
Status
Not open for further replies.
Back
Top