Import text file into database table

[Marty]

I need to build a web page that allows the user to select a text file
and click a button to import the file into a database table. Does
anyone have any code that shows how to read a text file line by line
and save that data into an ODBC database (not SQL Server)? The text
file is not delimited in any way so we will have to parse the data.
Right now, I am mostly concerned with storing the data. The data will
be stored in an Oracle table so we will be using ADO with our ASP
code.

Thanks for any help.
Marty

[TomB]

You'll need to upload and read the data. I'd upload it, give it a unique
name and save it temporarily in the file system.
I'd then use fso to read the contents of the file
[url]http://msdn.microsoft.com/library/en-us/script56/html/sgWorkingWithFiles.asp?frame=true[/url]
[url]http://tinyurl.com/skpm[/url]

"Marty" <johnmark1515@yahoo.com> wrote in message
news:93e46033.0310270646.6ae7cd5@posting.google.co m...

> I need to build a web page that allows the user to select a text file
> and click a button to import the file into a database table. Does
> anyone have any code that shows how to read a text file line by line
> and save that data into an ODBC database (not SQL Server)? The text
> file is not delimited in any way so we will have to parse the data.
> Right now, I am mostly concerned with storing the data. The data will
> be stored in an Oracle table so we will be using ADO with our ASP
> code.
>
> Thanks for any help.
> Marty