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.

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


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

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

Tim wrote:

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


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

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)

"Tim" wrote in message
...
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...


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

yeah well you gotta pretend the new technologies are essential... <wink
<wink :)


"Bob Phillips" wrote in message
...
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)

"Tim" wrote in message
...
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...


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

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)

"Tim" wrote in message
...
yeah well you gotta pretend the new technologies are essential... <wink
<wink :)


"Bob Phillips" wrote in message
...
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)

"Tim" wrote in message
...
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...


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

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.