Searching multiple excel sheet using a vb.net app

[Scott]

I want to search 5 or 6 very big excel spreadsheets looking for specific
data held in them. The search would be using clients surnames and maybe
postcodes to eventually find the correct person. Once this is done I wish
to either see there full details or have a display of what filename they are
in and what row of the sheet...

This in theory should be a run of the mill thing but i cant think where to
start...

Scott

 

[Ilyan Mishiyev]

When you say big, how big they are? How many rows in each?
I think there is a limit of 32K rows per excel file, but I might be wrong
though.

One solution might be trying to connect to excel, using it as a database,
and then use a select statement, with the name of the sheet, i.e. "SELECT *
FOM [sheet1$] WHERE ..."

Check this: http://www.connectionstrings.com/

Ilyan

 

[Scott]

I think each excel sheet is no bigger than 10,000 rows...

So will I be able to insert the lastname "Smith" and get results from all 6
spreadsheets quickly???

Scott

When you say big, how big they are? How many rows in each?
I think there is a limit of 32K rows per excel file, but I might be wrong
though.

One solution might be trying to connect to excel, using it as a database,
and then use a select statement, with the name of the sheet, i.e. "SELECT
* FOM [sheet1$] WHERE ..."

Check this: http://www.connectionstrings.com/

Ilyan

I want to search 5 or 6 very big excel spreadsheets looking for specific
data held in them. The search would be using clients surnames and maybe
postcodes to eventually find the correct person. Once this is done I wish
to either see there full details or have a display of what filename they
are in and what row of the sheet...

This in theory should be a run of the mill thing but i cant think where
to start...

Scott

 

[scorpion53061]

I would load the contents of the sheets into a dataset(s) and search
that way because it would be faster than using the bulky excel search
methods to find it.

I think each excel sheet is no bigger than 10,000 rows...

So will I be able to insert the lastname "Smith" and get results from all
6
spreadsheets quickly???

Scott

When you say big, how big they are? How many rows in each?
I think there is a limit of 32K rows per excel file, but I might be
wrong
though.

One solution might be trying to connect to excel, using it as a
database,
and then use a select statement, with the name of the sheet, i.e.
"SELECT
* FOM [sheet1$] WHERE ..."

Check this: http://www.connectionstrings.com/

Ilyan

I want to search 5 or 6 very big excel spreadsheets looking for specific

data held in them. The search would be using clients surnames and maybe

postcodes to eventually find the correct person. Once this is done I
wish
to either see there full details or have a display of what filename they

are in and what row of the sheet...

This in theory should be a run of the mill thing but i cant think where

to start...

Scott