Powerbuilder import excel file

Anybody know about update database different way. Please help me I am so tired t How to share the datawindow to inner datawindow of nested datawindow How to share the datawindow to inner datawindow of nested datawindow.

I have a CSV file like that 01, abc, def, , 0, 1, , a 02, "hello, wrold", , 1, 2, , b how to import into datawindow in PB7. After that's done and working, the. You can create a transaction object and bind it to a datawindow with SetTransObject, then just use Retrieve. Or you can look into the ImportFile or ImportStri NET, are not sliding up Hi, Problem: datawindows in composite datawindow used in "datawindow.

NET", are not sliding up , if one dw is not visible or did not retrieve data. Resulting in unwanted spaces. The height of blank white space is equal to the height of the datawindow art design time. When I looked at the generated JavaScript, I noticed there is "div" for the datawindow with height 0. But slides up ok when exported to pdf using saveas on web and in PB Also s How to import a excel sheet in a datawindow?

The ImportFile function only inserts data tab-delimited text or dBase format 2 or 3. What about reliability? Thanks for your help! OLE is slow. The ODBC method using a datawindow will be much faster.

Similar Artilces: importing an excel file into a datawindow hello everybody I am trying to import an excel file into a datawindow like a text file. Is there any method or work around to achieve this. An alternate which i thought was using oleobject, opening the excel file and using SaveAs to save into a text file for import into a datawindow.

Thank in advance Magesh Babu. Import excel file into datawindow Hi to all , How can i import excel file into datawindow? How to import Excel file to datawindow? You need to setup a Named Range in Excel with the first row containing column headers.

Techwave www. Import Excel file in datawindow open datawindow at runtime and save data in Excel file then update that Excel file, Now I want to import Excel file into datawindow then update oracle database. So anybody have clue please send me email. However, some of the columns contain alphabetic data that contains several lines of text. The file has 2 sheets and these sheets must be imported into 2 differenct db tables.

First thing, there's nothing automagic, along the lines of a one-line solution that you could get for other file formats. There's a manual method, there's a scripting approach, and you can probably merge the two as a third option. Toggle Submenu Categories Recent Tags. View Replies 1. Thank you in advance. Profiler samples: Both Listing have same archive. PDF Generation. Who is viewing this page.

Responses 1. Likes Latest Oldest. Hi, Use dw. ImportFile to import from Excel file into a DataWindow.