CSV load through ASP to SQL DB

[DataLust]

I'm trying to Load a CSV into a SQL database using ASP, since that is the only access I have to the database. I'm planning on reading each row and inserting it into a load table (one row at a time), then completeing the action using the load table once all the data is loaded.

The question is: Is there a better way to load the data with ASP than one row at a time? Can I load an Array and shove that into SQL?

 

[ehsant]

Hi ...
I think you are using FileSystemObject.
if so, it has a method for OpenTextFile named READALL
you can do it.
it reads all the text file and stores it int an array(each line in one row)
then you can use that array.
----
TNX.
E.T.