What kind of problems were you having? I am just wondering because of our
prior discussions. There is a new DBD::Excel available (released few days
ago partly due to our heated discussion on this). If you ever try that
driver let us know if that solved any problems.
Ilya Sterin
-----Original Message-----
From: Jeff Urlwin [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 07, 2001 9:57 PM
To: Thomas A. Lowery; [EMAIL PROTECTED]
Subject: RE: Extract data from MS Excel Spreadsheets. Can it be done?
I found, over time, that DBD::ODBC had problems with Excel. I would save
the Excel sheet as .csv and used DBD::CSV, instead. My use was a one way
conversion/update of Oracle from the spread sheets. I made a macro for the
data entry people to update the .csv file without having to think too
hard...
Jeff
> -----Original Message-----
> From: Thomas A. Lowery [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 01, 2001 8:14 AM
> To: '[EMAIL PROTECTED]'
> Subject: Re: Extract data from MS Excel Spreadsheets. Can it be done?
>
>
> Yes, DBD::ADO or DBD::ODBC. Both will talk to Excel and Access.
>
> Tom
>
> On Tue, May 01, 2001 at 12:38:45PM +0100, Kutler, Christopher wrote:
> > Hi,
> >
> > Does anyone know whether it is possible to connect to an Excel
> spreadsheet
> > and extract data in a way similar one would do with an Access
> database? If
> > so, how?
> >
> > thanks in anticipation
>
> --
> Thomas A. Lowery
> See DBI/FAQ http://tlowery.hypermart.net
> _________________________________________________________ Do You
> Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
>