A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
connect to microsoft excel db driver
Joined: Aug 10, 2007
Aug 11, 2007 11:48:00
i have some problem when making a connection to microsoft
database driver from the
bean. Could any one provide me the code how to establish the connection.
Thanks in advance.
[ August 11, 2007: Message edited by: Bear Bibeault ]
Joined: Feb 24, 2006
Aug 11, 2007 12:26:00
What does this have to do with
? Probably belongs in the
forum ? What errors are you facing ?
SCJP 6 articles
SCJP 5/6 mock exams
More SCJP Mocks
mohan kumar r
Joined: Jan 19, 2006
Aug 12, 2007 09:33:00
add mirosoft excel driver and create data source
control panel>adminstrative tools>Datasources.
remaing code is same as connecting to oracale or some other DB but table name is the name of work sheet with a $ appended to the end.
I agree. Here's the link:
subject: connect to microsoft excel db driver
problems with microsoft excel driver
data source name too long
what is the limitation of getString(column name)?
creating a DSN
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015