What's an easiest way to import an Exel file to a DW?

This is a multi-part message in MIME format.

------=_NextPart_000_0052_01BF951A.45FDC310
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Currently, I have to convert the selected Excel file to a text file =
format before I can import it to a datawindow.  Is it a better way?

Thanks

------=_NextPart_000_0052_01BF951A.45FDC310
Content-Type: text/html;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Dwindows-1252" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3013.2600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Currently, I have to convert the =
selected Excel=20
file to a text file format before I can import it to a datawindow.&nbsp; =
Is it a=20
better way?</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV></BODY></HTML>

------=_NextPart_000_0052_01BF951A.45FDC310--

0
T2
3/24/2000 4:51:06 AM
sybase.powerbuilder.datawindow 28057 articles. 5 followers. Follow

1 Replies
545 Views

Similar Articles

[PageSpeed] 43

This is a multi-part message in MIME format.

------=_NextPart_000_017E_01BF97D3.B08EB7A0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

1) Define an ODBC datasource to read your Excel file.  Then you can use =
a data pipeline.
2) Alternatively, use OLE to read the spreadsheet.

--=20
Terry Dykstra (TeamSybase)
Canadian Forest Oil Ltd.
Check out Sybase Developer's Network: http://www.sybase.com/sdn

  T2 <tung_t_tran@hotmail.com> wrote in message =
news:Ev2IR1Ul$GA.201@forums.sybase.com...
  Currently, I have to convert the selected Excel file to a text file =
format before I can import it to a datawindow.  Is it a better way?

  Thanks

------=_NextPart_000_017E_01BF97D3.B08EB7A0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>1) Define an ODBC datasource to read your Excel =
file.&nbsp;=20
Then you can use a data pipeline.</FONT></DIV>
<DIV><FONT size=3D2>2) Alternatively, use OLE to read the=20
spreadsheet.</FONT></DIV>
<DIV><BR>-- <BR>Terry Dykstra (TeamSybase)<BR>Canadian Forest Oil =
Ltd.<BR>Check=20
out Sybase Developer's Network: <A=20
href=3D"http://www.sybase.com/sdn">http://www.sybase.com/sdn</A><BR></DIV=
>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: =
0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
  <DIV>T2 &lt;<A=20
  =
href=3D"mailto:tung_t_tran@hotmail.com">tung_t_tran@hotmail.com</A>&gt; =
wrote in=20
  message <A=20
  =
href=3D"news:Ev2IR1Ul$GA.201@forums.sybase.com">news:Ev2IR1Ul$GA.201@foru=
ms.sybase.com</A>...</DIV>
  <DIV><FONT face=3DArial size=3D2>Currently, I have to convert the =
selected Excel=20
  file to a text file format before I can import it to a =
datawindow.&nbsp; Is it=20
  a better way?</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=3DArial =
size=3D2>Thanks</FONT></DIV></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_017E_01BF97D3.B08EB7A0--

0
Terry
3/27/2000 5:03:24 PM
Reply:

Similar Artilces:

Using 6.5 DW's in 7's HTML and ActiveX DataWindows
PB 7 has the new HTML DataWindow and the ActiveX DataWindow. Both just read PBD's to extract a specific datawindow to process. Question: Can these new facilites read PB 6.5 datawindows? This would be nice to ease transition. We can still develop DW's in 6.5 until we thing 7.0 is stable and we can distribute to our developers. Don Weimann 1. No, it won't read PB7 datawindows. HTMLDW is implemented by adding properties to the datawindow object. 2. PB7 is, AFAIK, rather stable. I've invested a great deal of time to ensure that it, and in particular, the HTM...

What's the fastest way to export and import DW data?
Our app's resize service sometimes sets the height of the details band to 0, before it resizes a datawindow. This makes the resize much faster, but it has a side effect: If the user has typed anything into the datawindow, and that datawindow is then resized, the data the user has entered will be cleared. I'm looking for a way to quickly export the newly entered data before the resize, and import it back afterwards. This is not such a hard task in general, but I'd like it to be done as quickly as possible, in order not to stall the resize. Bonus question - is there an...

superreview granted: [Bug 361730] Seamonkey _deletes_ mail file if the mail file's size is greater than 2GiB and the .msf file has zero length : [Attachment 246709] biesi's proposal
Scott MacGregor <mscott@mozilla.org> has granted David Bienvenu <bienvenu@nventure.com>'s request for superreview: Bug 361730: Seamonkey _deletes_ mail file if the mail file's size is greater than 2GiB and the .msf file has zero length https://bugzilla.mozilla.org/show_bug.cgi?id=361730 Attachment 246709: biesi's proposal https://bugzilla.mozilla.org/attachment.cgi?id=246709&action=edit ...

superreview requested: [Bug 361730] Seamonkey _deletes_ mail file if the mail file's size is greater than 2GiB and the .msf file has zero length : [Attachment 246709] biesi's proposal
David Bienvenu <bienvenu@nventure.com> has asked Scott MacGregor <mscott@mozilla.org> for superreview: Bug 361730: Seamonkey _deletes_ mail file if the mail file's size is greater than 2GiB and the .msf file has zero length https://bugzilla.mozilla.org/show_bug.cgi?id=361730 Attachment 246709: biesi's proposal https://bugzilla.mozilla.org/attachment.cgi?id=246709&action=edit ...

Open file in browser or application getting the page's name as the file's name
Hi, I'm am trying to get a file to open in either a browser or application depending on the mime type. I'am using the following code in the page load. protected void Page_Load(object sender, EventArgs e){ if (!IsPostBack)    { DocumentInfo document = (DocumentInfo)Session["View_Document"]; StreamFile(document.Document, document.DocumentName, document.FileType.MimeType); } } }private void StreamFile(byte[] fileData, string originalFileName, string mimeType) { try { Response.Clear(); Response.ContentType = mimeType; Response.AddHeader("Con...

How store ultralite10's database file(.udb file) in wince emulator's store card?
i use ultralite10(develop version) in vs2005 with wm5.0 emulator. i find i can't store .udb file in emulatotr store card.it will make a "SQLE_MEMORY_ERROR", why happened this? what should i do so i can may the .udb file in emulator's store card? We haven't had any issues with this. You can post more details about how you attempted to connect or open a tech support case Mike > We haven't had any issues with this. You can post more > details about how you attempted to connect or open a tech > support case > > Mike > > t...

dddw's on html dw's
I have an html dw that has a dddw control on it. The purpose of this dddw is to provide the user the ability to select 'vendors' that are relative to the 'vendor item' the user is trying to add to the database. In order for this to work correctly, the dddw must have retrieval arguments set that only pull the vendors that are relative to that user - client # and store #. Both of these fields exist on the vendor table - which populates the dddw - and the vendor item table - which is what the user is updating. My problem is that I cannot seem to establish a link between ...

dddw's on html dw's
I'm having an 'irrating' problem in creating an html dw that contains 2 dddw's. Whats supposed to happen is that when the html dw is invoked, it is passed 2 arguments that are used to specify who the user is - company number and user number. Based upon these arguments, the first dddw is supposed to populate a list of available selections based upon entries in a secondary table - company # and user # are contained in the secondary table that the dddw accesses. Based upon the user's selection from the primary dddw, the second dddw is supposed to be populated with the...

dddw's on html dw's
HELP!! We've run into a MAJOR problem with using dddw's on html dw's that require retrieval arguments. The html dw's use variables that are set based upon the user logon which are the exact same variables that are needed as the retrieval arguments for the dddw's. We haven't been able to find a way to pass these arguments within the html dw to the dddw control either through the use of session variables or linked arguments. If anyone has an example of how this is done or a suggestion on how to accomplish this I'd be forever grateful. TIA Brad ...

Importing to 'New' from 'Old' Thunderbird files
Searching Thunderbird I found 'Importing' but it wont work for me. I have a Windows XP which failed, (viruses, etc.) and the hard disk Drive C has been installed on the new XP as Drive 'E' (backup). The teccihie installed Windows etc on the new Drive C and REMOVED Windows programs from Drive E. When I attempted to get into Thunderbird, I was initially taken back to Step 1 to setup my own e-mail and language NewsGroup. My dread is I have lost the old Thunderbird Messages and Address Book which theoretically should be on Dive E. Can I rescue them - what are the ...

Using dddw's on html dw's
I've posted this to the powerbuilder.datawindow forum but was not quite sure if that was the correct forum. Here's the problem: I've created an html dw that uses 2 dddw's. It is invoked by the passing of 2 arguments that are passed when then user signs on to the system. These arguments are captured in the DynaScript of the html page via the session variable. Here are the questions: (1) How do I pass the initial arguments - company # and user # - to the primary dddw so that only those records on the table that the dddw is using are available and (2) when the use...

What's witht the .exe's when dling a file
I was downloading a debial iso to a directory in my E: drive. In the middle of it I got a popup saying that my C: drive was filled and that there wasn't room for an [somerandomlookingstring].exe there. Why is moz creating an exe for a download? -- Mark Heaely marknews(at)healeyonline(dot)com On 03/10/27 22:50 Mark Healey apparently typed: > I was downloading a debial iso to a directory in my E: drive. In > the middle of it I got a popup saying that my C: drive was filled and > that there wasn't room for an [somerandomlookingstring].exe there. Unless your ...

Two DB's & DW's
Hi I have connections with to DB's. One with the SQLCA-Transaction object and another one with a user-created one "gtr_sqlca". I have datawindows in the application for both DB's. But all the datawindows try to retrieve the data from SQLCA. How can I tell PB that some DW's have to retrieve data from "gtr_sqlca"? Thank you very much Best regards Andreas did you call the settransobject function in the open event of the window? ex. dw_1.SetTransObject(gtr_sqlca) Andreas Keiser wrote: > Hi > > I have connections with to DB...

How to convert MS SQL's 'smalldatetime' to PB 'date' in DW?
Suppose I have a Powerbuilder datawindow with a column of type 'date'. I also have a MS SQL 7 database table with a column of type 'date' where 'date' is a MS SQL's user defined type which maps to MS SQL's 'smalldatetime'. Now I retrieve the datawindow. On Windows XP Professional in the datawindow I have a beautiful date, let's say '1-2-03' but on Windows 95 I have garbage: '??-??-1241' or similar. Here is my question: how to convert the MS SQL's 'smalldatetime' value to the PB 'date' type 'on-the...

Web resources about - What's an easiest way to import an Exel file to a DW? - sybase.powerbuilder.datawindow

Resources last updated: 2/4/2016 9:41:01 AM