read a CSV file and update an Access DB using ASP
Posted on 2006-10-26
I have done a ton of database programming using SQL Server, Access and ASP.
I have a new challenge now.
I need to build an ASP script where I read a CSV file, break out the fields and then update my DB using ASP. Has anyone done anything like this before? I'm thinking it is fairly easy maybe using something like the "split" function?
Looking for ideas on how to accomplish this and a small snippet of code if possible.'