Webmaster Forum / ASP / Database Access / February 2007

Where to start..haha.

My boss has me dev-ing a search page that will read from a CSV file.

It has to be in ASP (and the old one - not .NET) and we cant use a
real database -- trust me, I asked.  So we are stuck with a CVS file
that I want to use as a data source that I can run SQL queries
against.

So...how?

Really, starting from scratch -- how.  Like, how do I connect the CSV
file, do I need to define it?  I read about a "Microsoft Text Driver"
and I copied some code and recieve an error "Object needed on line x"
which translates to "I have no idea if "oConn.Open" is a pre-defined
function/object or if I need to create the object first.  Then, once
its connected, can I simply run a query against it like it was a db?

So, if one of you could be so kind to explain, step by step how to do
this it would be GREATLY appreciated!