By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,795 Members | 1,216 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,795 IT Pros & Developers. It's quick & easy.

using excel file for database

P: n/a
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
Nov 21 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"sympatico" schrieb
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
Nov 21 '05 #2

P: n/a
http://www.codeproject.com/dotnet/ExportExcelData.asp

http://www.dotnet247.com/247referenc...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.

"sympatico" <fe******@a1vbcode.com> wrote in message
news:Br*********************@news20.bellglobal.com :
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


Nov 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.