I'm using Linux as server, and Window as client. I put the Excel file to Linux, and then JavaBean read the Excel file. The client can view the data through the brower.

Is this possible to place the Excel file to Linux , not Window ?

__________________
The OXYGEN
Delivers edgy, intelligent Technology to all...

It's not quite clear what you want to do.

1) Do you want to connect to an Excel file over JDBC? This would be quite similiar like to any other data source / DBMS.

But I know this approach only with JDBC-ODBC. Since Excel can't run on LINUX, you would have to do a remote connection. There seems to be an ODBC for LINUX, but I don't know much about it. (It was mentioned in this forum sometimes - search, if you want.) But I think you would need a Win machine as "server" then which runs your Excel.

or

2) Does your Java Bean (planned or existing?) read the Excel file format directly, as File I/O, without calling the Excel app? Then you would need no JDBC, no Excel, only the Excel file and the logic how to interpret it.

If this is available, then this JavaBean will run on LINUX of course and can be simply used by your server app.

If you want to program this Bean yourself, I would not do the hard work of understanding the Excel file format, but rather cause the "creator" of the Excel file (a user on a Win machine using Excel app) to export the data as a csv file. This can be read much easier. Since it has internally the same logical structure like a RDBMS table, you maybe can connect to this flat file over JDBC.

Probably you can find a lot of help for both ways, in this forum and elsewhere.

__________________
cheers
Aman

I need to know how to write from Excel to Access and to read from Access back
to Excel via ODBC/JDBC.

Any suggestions? I've heard it's pretty complicated...

The easiest way is to configure a DSN that uses the ODBC driver for Excel. Then your Excel spreadsheet looks like a database.

__________________
Krishnakumar.S
Beware of Everything -that is un true; stick to the Truth shall succeed slowly but steadily

Hi all,

Since Excel comes with an ODBC driver, we'll use the JDBC-ODBC bridge driver that comes packaged with Sun's JDK to connect to our spreadsheet.

Here is the sample for excel integration in jdbc.

how to search the word and excel document that have stored sql server?

__________________
.....................................
''''''Rajesh''''''
Ants. . . . . . Like me

- setup the JDBC crawler to crawl the proper table in MS SQL Server


for more visit here...

__________________
S.VinothkumaR
Behind me is infinite power,
Before me is Endless Possibility,
Around me is Boundless Opportunity,
Why should I fear!

Hi friends...,


I am using JSR 82 bluetooth api for developing bluetooth based application.

i am not able to find API for switching on the Blue tooth.

Can any help on this regard.

Thanks in advance!

__________________
thanx n regards
jeyaprakash.c

hi Prakash!

j2me does not provide any api for switch on the bluetooth device we can find the status(on-off) of our bluetooth device using jsr 82.

__________________
S.VinothkumaR
Behind me is infinite power,
Before me is Endless Possibility,
Around me is Boundless Opportunity,
Why should I fear!

Hi all,

I'm getting an odbc error doing a select on an excel file using jdbc-odbc.

Here is statement

"select * from Sheet1",

with the excel file having a Sheet1 worksheet and some data.

The error says: "The Microsoft Jet engine could not find the object "Sheet1".
Is this because of a special syntax requirement for the excel odbc driver? i've successfully made a connection to the excel datasource, but
my select sql doesn't go through. can anyone shed light on this one?

__________________
Krishnakumar.S
Beware of Everything -that is un true; stick to the Truth shall succeed slowly but steadily

When you try to import or link a Microsoft Excel spreadsheet, if you click Show Named Ranges in the Import Spreadsheet Wizard or the Link Spreadsheet Wizard, you may receive the following error message:

The Microsoft Jet database engine could not find the object '<name of selected range>'. Make sure the object exists and that you spell its name and the path name correctly.

You may also receive this error if you use a macro or a Visual Basic for Applications procedure to import or link the spreadsheet.

NOTE: This error message may occur if you convert a Microsoft Access 2.0 database to Access 2000, and the database includes a TransferSpreadsheet macro action or Access Basic code with a Range argument that contains the sheet name along with a named range.

For example:

__________________
S.VinothkumaR
Behind me is infinite power,
Before me is Endless Possibility,
Around me is Boundless Opportunity,
Why should I fear!