using excel file for database

[sympatico]

Heres the situation: I currently have an excel file with approximately 3500
project entries
with fields such as job number, management, address, project description,
type, etc.,

Is there a way to make a gui program where a typical user can search the
database (excel file) and display the results in a textbox?,

Generally as follows:
1) User enters text in combobox to search for number, address, name, etc.,
then hits go button,
2) program reads excel file
3) user info is displayed in textbox ( display shows all fields based on
input, such as job number, address, descript, etc)

so if I type washington, it will display all the projects with washington in
it

 

[Arne Janning]

Heres the situation: I currently have an excel file with approximately
3500
project entries
with fields such as job number, management, address, project description,
type, etc.,

Is there a way to make a gui program where a typical user can search the
database (excel file) and display the results in a textbox?,

Generally as follows:
1) User enters text in combobox to search for number, address, name, etc.,
then hits go button,
2) program reads excel file
3) user info is displayed in textbox ( display shows all fields based on
input, such as job number, address, descript, etc)

so if I type washington, it will display all the projects with washington
in
it

HOWTO: Use ADO.NET to Retrieve and Modify Records in Excel
http://support.microsoft.com/?id=316934

Cheers

Arne Janning

 

[scorpion53061]

http://www.codeproject.com/dotnet/ExportExcelData.asp

http://www.dotnet247.com/247reference/msgs/37/186640.aspx

http://www.knowdotnet.com/articles/exceldatasource.html

Bill Ryan wrote this article and is one of the greatest authorities on
this subject you will find.