Excel/Text to HTML using ASP

S

shiime

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.
 
T

Tim

hmm its a pitty ur not using asp.net as you can use an oledb database
connection object to connect to an excel file natively and then read it into
a dataset. ahh beautiful stuff...
 
S

shiime

we can talk... i can run it on .NET as I havent started yet. I have got
a basic handle on .net but i'm more fluent in vanilla asp. If you want
more details let me know
 
B

Bob Phillips

That can be done in vanilla VB, or (god-forbid) VBScript, it doesn't need
Net

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
B

Bob Phillips

You'll give IT a bad name<v bg>

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
A

Alan Howard

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
 
Top