Data from Spreadsheet

[Atlas]

I was wondering if these is a way that I can use the SQL Select statement to gather data from an excel spreadsheet. I looked through the documentation on the Select statement and didn't see anything on this subject.

Didn't know if it could be done but thought I would ask the question.

Thanks

Atlas

 

[Mike Gagnon]

Atlas

No, you would have to either import it into a table, or automate Excel to retreive the data.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[Mike Lewis]

Atlas,

You could always set up an ODBC data source to point to the spreadsheet (assuming you have an ODBC Excel driver), then use SQL pass-through to send a SELECT statement which retrieves the data.

But you will find it vastly simpler to import the sheet into a VFP table, as Mike Gagnon suggested.

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com