Thanks Terry for pointing that we do have this option on a CB within a
Form. I was looking at this only from the Report Painter's perspective - not
the Form Painter which has some more functionality.
Post by Terry Dykstra [TeamSybase]You can use the ImportFile action on a command button. That gives you
txt, csv, xml import options.
To import from Excel, create a pipeline. You can add the pipeline to your
executable. You will need to define an Excel ODBC DSN. In the
spreadsheet you create a named range, with the first row of the named
range containing the column headers.
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
http://my.isug.com/cgi-bin/1/c/submit_enhancement
Post by Chris PollachHi Ales;
You can do this in the Report Painter but there is no Import "action"
item for a CommandButton otherwise you could create a user application
feature around it! It seems strange that IM does not support any
Importation as we do have a SaveAs action for exporting data. I would
like to suggest that you add this to the IM enhancements located on the
ISUG website at: http://www.isug.com/common/EnhancementsProcess.html
1) Load the Excel data into a database table and then have IM go after
this via its normal SQL prowess.
- OR -
2) Create an ODBC connection for the Excel file and have IM go after this
via its normal SQL prowess.
HTH
--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com
Post by Ales NovotnyHello,
is it possible to import data from excel into freeform or grid form in
Infomaker?
Or it is possible only in PowerBuilder?
Thanks for the answer.
Ales