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.