Ok, I finally figured out a way to do it to where it isn't a strain on the server, but my loop isn't working.
Heres the code:
[PHP]
Dim FSO, CSV, CSVHeaders, lineCount
set FSO = createobject("s cripting.filesy stemobject")
set CSV = FSO.opentextfil e(server.mappat h("excel\Master .csv"))
' Skip the header line and move to the next...
User Profile
Collapse
-
You could do
Response.AddHea der "Refresh", "1"
or I've also used
Response.Redire ct("pagename.as p")
just redirecting it to the same page, thats the only way I know to do it immediately.Leave a comment:
-
CSV to Access in ASP...
I've been trying to figure this out on my own for two days and I give up at this point. I'm creating a web administration interface, and the user would like to be able to upload a CSV file, and have it post to the database.
I originally tried using the microsoft text driver, and that worked great. However, putting the CSV in an array to save the information and then open the access database didn't work, because the CSV is so huge,...
No activity results to display
Show More
Leave a comment: