John:
Check into creating a SQL DTS package to handle (and automate) the excel to
SQL table process. The next step is to full-text index the SQL table in
question to allow you to perform full-text querying on the data. With a
proper full-text catalog created by the full-text index, you can now use SQL
keywords such as CONTAINS and FREETEXT to search the data and return
appropriate hits. There are performance considerations when your data gets
to be more than a million rows.
Check out the SQL Server Books Online for more specific information. You may
also want to create more limited searches based on a subset of fields
contained in the table (a most used feature) for more frequent, performance
minded searches.
Hope this gives you a starting point.
John Sturgeon, MCP, MCSD
BizTech Solutions, Inc.
"John Saunders" <js*******@gsorad.com> wrote in message
news:eZ**************@TK2MSFTNGP11.phx.gbl...
Ok, this is what I need to accomplish.
We have a huge excel file that comes in daily. I need the server to grab
this excel file each day and import the data into a SQL database. Once
that is accomplished, I want the web app to allow the user to search any
data in the table. This is overwhelming to me.. I don't know where to
begin. The excel file has 193 fields and tons of records. Any advice on
this would help me tremendously.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!