Hi, Does anyone know how to use

[oraclec]

Hi,

Does anyone know how to use ASP to read data from a csv file and do an INSERT into SQL Server 2000 database? Both my csv file and sql db allows null values in their columns.

I went to this link: (reads from csv file and writes to HTML page ~ I figured would be similar to writing to SQL Server)

http://www.codeave.com/asp/code.asp?u_log=101

and tried the method, but got these funny characters ÐÏࡱá displayed on my HTML page instead.


|*~Oraclec~*|

 

[LogicalmanUS]

oraclec,

You are looking at this the wrong way. Don't use the ASP to read the file and then Insert it into SQL Server, simply create a SProc on the server, with a single parameter for the file path, and call the SProc from the ASP passing the filepath as the parameter.

The Sproc can do the rest and return a success or failure code to the ASP when done.

Logicalman