Depending on your data and requirements OLE DB to Excel directly may not be
the best approach - the provider still requires that data in the file is
structured as a distinct list/table. I find CSV and a custom parser work
best.

I have some code for a VB COM component that picks up CSV files and inserts
the contents into a database. The project is still in development so the
code isn't 100% complete but it may get you started. I could also provide
you with code for interfacing with MS Full-text search (SQL Server) and/or
MS Indexing Service (file system searches).

Flick me an email at alan dot howard at unifirst dot co dot nz if you want.

Alan

"shiime" wrote in message
u...
I have a website I am about to build and I need an ASP programmer to
develop a component of the site which will read products from a text
file (we have Excel versions available too) and parse this into a
recordset which can be searched and displayed on the site. I'm thinking
the Excel version is the best shot.

More information can be provided upon request. Please email simon (at)
simonbank (dot) com

I have a few weeks to get this completed in, but the sooner it can be
done the better.