Uploading csv file( .txt) into access 2000 database using Classic ASP, vb Script
Posted on 2006-03-28
I already have a database with information in it but I want to add more information to this same database without overwriting anything. This information will come from a csv file that is a .txt file.
The table is already created in the database, waiting to be populated.
I am not sure how to do this:
There needs to be an Upload feature. I will click on the Browse button, browse to the "filetoupload.txt" file which is the csv file. This file contains information of this format one record per line:
"21313","john","smith","123 Black Road","Pinecrest","PA","21345","09/04/2006"
So, now when I upload this file it should know that the first field is [id] and the second field is [first name] and the third field is [last name], so on and so forth. And it sticks it in the right table by creating a new record with all this infofrmation from the .CSV file.
This csv file will not be large at all, say 50 records or so, maybe less.
No idea how to do this as I am a noobie and some hand-holding is necessary...[:0)
Indebted to you.