PDA

View Full Version : searching excel spreadsheets?



SoL-LV
26 Dec 2005, 03:45 PM
hey, can anyone point me into the right direction?
I'm trying to create a searchable database that can search a folder containing simple order-tracking excel spreadsheets.

DanInManchester
02 Jan 2006, 09:17 AM
I think the problem needs some clarification.

Is this to be a web based application or software and if so what platform?

When you say a database what is the database to hold? is it simply an index of the spreadsheet files and their location or something more?

What do you need to search for and is it the database or the spreadsheets themselves?

If I were you I would move away from excel and use a database only as spreadsheets aren't really designed for managing data for this type of application. If you're stuck with the spreadsheets you can probably work round it.