I am trying to create a bulk insert into a MSSQL database from an ASP VBScript page on an intranet site. I am wanting the user to be able to browse for the file with a simple form and submit into this insert page.
I am newer to aspvb however am fairly familiar with SQL other related languages. I have tried the bulk insert command in the server's query analyzer and it works fine but somehow I'm not able to connect the dots into asp.
I have searched EVERYWHERE and a lot of people elude to this being possible and an easy solution but noone actually explains or gives an example. PLEASE HELP if you can.. this is driving me crazy.
Evan Bledsoe