I need to make a gigantic collection of excel sheets searchable from a web interface.
I needentire rows fetched into a webpage depending on the users query.
Mind you I'm not searching the names (filenames) of these excel files, but
the contents inside the excel file. E.g. in a file test.xls, if I search for the word
"test1" from the web interface, the entire row in the excel file containing
the word test1 should be displayed.
One way out is to dump the contents of the excel sheets into a database, and
search the database via ASP.
For this, can anyone tell me how to efficiently dump the contents of an excel
sheet into SQL server?
Or if anyone can suggest an alternate strategy for searching this mammoth
collection of excel files' contents, if would be great.
Thanks a lot.
To dump excel data into database, you have serveral options: DTS (Import/Export Wizard), bcp utility, BULK INSERT, etc. Seach with these key words in SQL Books Online, you can find how to use them.
No comments:
Post a Comment