Linking to Excel from ASP

[AlShack]

Hi all

Anyone got a duffer's guide to retrieving Excel data into a SQL database using classic ASP? I've tried a few connectuion strings but am struggling. (I can provide details of what I've tried if you like!).

I'm developing on a Vista machine with Office 2007, so I'm not sure if this has any bearing on things? Will the finished result (hosted on Catalyst2 servers) have to be any different?

Cheers
Alan

[WhiskyFudge]

It is possible using Jet Connection. Which then allows you to query the sheet using normal sql. I have a solution using the following connection string:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=File.xls;Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1

I have this working for the old excel format. In theory the new 2007 excel format can be queried by the use of XML but not something I've tried as of yet.

It's been a year or two since I wrote my code so my memory is a bit fuzzy. But I know that I can't test the above code on my dev machine (Vista x64). I'm not sure if its the 64bit or the OS that causes the problem. I suspect it's either the former or both.

I would recommend your first port of call would be to see if you have Jet installed.

HTH

Jas

[AlShack]

Excellent - ta Jas.

It works on the Catalyst2 servers, but not on my laptop so I guess I'll be developing it 'live'!

Cheers
Alan