That's a tough question! First, Excel is Windows based. You must export the
file to a different format. Office relies on DCOM (Distributed Component
Object Model). When Excel opens and inquires the system about opening a
file, the drivers respond and say "OK, but what version are you?". After
this dialogue, the system will search 1) is Excel open (vRunningTables in VB
and I forget VC++ table name) 2) if it is open, is the particular file open
and 3) is the file open in the same spot as the requested file is going to
open. If these first 3 conditions are met, away you go. If not, a new
version of Excel opens. To just "link it" into MySql, the database has to
support the communications of DCOM i.e. simple things like formatting. (
This will be easier with .NET because the programming environment is going
to an IL (interface language) - no longer procedural, but interpretive).

Thanks,
Pat
gannpm@h...


-----Original Message-----
From: Java Server digest [mailto:pro_java_server@p...]
Sent: Sunday, March 25, 2001 2:04 AM
To: pro_java_server digest recipients
Subject: pro_java_server digest: March 24, 2001

PRO_JAVA_SERVER Digest for Saturday, March 24, 2001.

1. Develop charts from a link

----------------------------------------------------------------------

Subject: Develop charts from a link
From: Amit Sethi <amsethi@y...>
Date: Sat, 24 Mar 2001 01:48:36 -0800 (PST)
X-Message-Number: 1

Hi,
Sir I'm struck on thing.As I've a link thru' which
I've to make the dynamic charts....Now this link I've
made possible to insert it into the databse but this
text is not fixed(doent follow the same pattern).
Actually this link gives me a Excel sheet.....I want
if there is any possiblity that i can put my Excel
data into the MySql so that I can retrieve it properly
and generate the charts.......
Plz assist me asap.......

Amit Sethi



---

END OF DIGEST

---
NEED TECHNICAL TIPS, TOOLS, AND INSIGHTS?  Is FREE okay?
Visit EarthWeb for the latest in IT Management, Software Development,
Web Development, Networking & Communications, and Hardware & Systems.
Click on http://www.earthweb.com for FREE articles, tutorials,
and discussions from the experts.
$subst('Email.Unsub')


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.236 / Virus Database: 114 - Release Date: 3/5/2001