The *easiest* way is to have the Excel5 user use the File/SaveAs option
to save the data in tab-delimited format. You make your DataWindow object
match with the same columns as the spreadsheet, you can use the
dw.ImportFile(...) function to read it in.
Unfortunately, the easiest way for the programmer is not always feasible
for the user. Users typically don't like the extra step, and you might not
be able to enforce the process.
The alternative is to use the ODBC Excel drivers, and set up a data
source. At run-time, you can attach to it with a transaction object (e.g.,
SQLCA, or one you create just for importing), and then can use normal
DataWindow Retrieve function.
The online help gives pretty detailed instructions on setting this up.
--dang
-----Original Message-----
From: Anirban Dutta [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 30, 2000 15:08
To: [EMAIL PROTECTED]
Subject: PFCSIG Import data from Excel
Hi,
Can anyone please tell me the easiest way to import data from excel5 to
Datawindow.
I am using PB7.0
Thanks in advance
Anirban
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS,
ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
