|
 |
asp_discuss thread: Tell me about excel
Message #1 by "Nguyen Toan Thang" <thangnt20@h...> on Tue, 24 Apr 2001 02:39:00
|
|
I want to make a convertion with database from clients in Excel format to
Server in Oracle format in order to make a contact between School and Home.
Excel sheets are mark(score) boards of pupils. I am running Intranet with
NT Server 4.0 (Option Pack 4) and Oracle 8i.
Can you tell me how to do a automatic convertion. Support me Ocx related.
Thank you Advanced. Your faithfully!
Message #2 by Hal Levy <hal.levy@s...> on Tue, 24 Apr 2001 09:37:34 -0400
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C0CCC3.B83B58C0
Content-Type: text/plain;
charset="iso-8859-1"
1. Have client upload the Excel Spreadsheet
2. Connect to the Excel Spreadsheet using ADO
3. Get the data
4. Connect to Oracle
5. Put the data
If you know all the people will be using IE5+ you can also create a Signed
ActiveX Control to run on the client machine that will connect to the
server.
Hal Levy
StarMedia Network, Inc.
Intranet Development Manager
-----Original Message-----
From: Nguyen Toan Thang [mailto:thangnt20@h...]
Sent: Monday, April 23, 2001 10:39 PM
To: asp_discuss
Subject: [asp_discuss] Tell me about excel
I want to make a convertion with database from clients in Excel format to
Server in Oracle format in order to make a contact between School and Home.
Excel sheets are mark(score) boards of pupils. I am running Intranet with
NT Server 4.0 (Option Pack 4) and Oracle 8i.
Can you tell me how to do a automatic convertion. Support me Ocx related.
Thank you Advanced. Your faithfully!
Message #3 by "Nguyen Toan Thang" <thangnt20@h...> on Wed, 25 Apr 2001 10:41:52 +0700
|
|
I hingly preciate your comment.
But could you show me the ASP script for uploading excel from cient
(Step1) and get the data (Step3)
Thank you very much
(Moderator's note - this is really supposed to be a discussion list, not a howto list.)
>From: Hal Levy <hal.levy@s...>
>Reply-To: "asp_discuss" <asp_discuss@p...>
>To: "asp_discuss" <asp_discuss@p...>
>Subject: [asp_discuss] RE: Tell me about excel
>Date: Tue, 24 Apr 2001 09:37:34 -0400
>
>1. Have client upload the Excel Spreadsheet
>2. Connect to the Excel Spreadsheet using ADO
>3. Get the data
>4. Connect to Oracle
>5. Put the data
>
>If you know all the people will be using IE5+ you can also create a Signed
>ActiveX Control to run on the client machine that will connect to the
>server.
>
>
>
>Hal Levy
>StarMedia Network, Inc.
>Intranet Development Manager
>
>-----Original Message-----
>From: Nguyen Toan Thang [mailto:thangnt20@h...]
>Sent: Monday, April 23, 2001 10:39 PM
>To: asp_discuss
>Subject: [asp_discuss] Tell me about excel
>
>
>I want to make a convertion with database from clients in Excel format to
>Server in Oracle format in order to make a contact between School and Home.
>Excel sheets are mark(score) boards of pupils. I am running Intranet with
>NT Server 4.0 (Option Pack 4) and Oracle 8i.
>Can you tell me how to do a automatic convertion. Support me Ocx related.
>Thank you Advanced. Your faithfully!
>
Message #4 by Hal Levy <hal.levy@s...> on Wed, 25 Apr 2001 09:50:18 -0400
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C0CD8E.A9B7A990
Content-Type: text/plain;
charset="iso-8859-1"
How to upload:
http://www.asp101.com/resources/saupload.asp
http://www.aspupload.com/
Get the data:
Use ADO to get the data
If you want to continue this, we should move to another list.
Hal Levy
StarMedia Network, Inc.
Intranet Development Manager
-----Original Message-----
From: Nguyen Toan Thang [mailto:thangnt20@h...]
Sent: Tuesday, April 24, 2001 11:42 PM
To: asp_discuss
Subject: [asp_discuss] RE: Tell me about excel
I hingly preciate your comment.
But could you show me the ASP script for uploading excel from cient
(Step1) and get the data (Step3)
Thank you very much
(Moderator's note - this is really supposed to be a discussion list, not a
howto list.)
>From: Hal Levy <hal.levy@s...>
>Reply-To: "asp_discuss" <asp_discuss@p...>
>To: "asp_discuss" <asp_discuss@p...>
>Subject: [asp_discuss] RE: Tell me about excel
>Date: Tue, 24 Apr 2001 09:37:34 -0400
>
>1. Have client upload the Excel Spreadsheet
>2. Connect to the Excel Spreadsheet using ADO
>3. Get the data
>4. Connect to Oracle
>5. Put the data
>
>If you know all the people will be using IE5+ you can also create a Signed
>ActiveX Control to run on the client machine that will connect to the
>server.
>
>
>
>Hal Levy
>StarMedia Network, Inc.
>Intranet Development Manager
>
>-----Original Message-----
>From: Nguyen Toan Thang [mailto:thangnt20@h...]
>Sent: Monday, April 23, 2001 10:39 PM
>To: asp_discuss
>Subject: [asp_discuss] Tell me about excel
>
>
>I want to make a convertion with database from clients in Excel format to
>Server in Oracle format in order to make a contact between School and Home.
>Excel sheets are mark(score) boards of pupils. I am running Intranet with
>NT Server 4.0 (Option Pack 4) and Oracle 8i.
>Can you tell me how to do a automatic convertion. Support me Ocx related.
>Thank you Advanced. Your faithfully!
>
|
|
|
View Cart
