Bulk Insert to SQL Server from ASP.NET

P

planetmatt

I need to create a page that bulk inserts a CSV text file into SQL
Server. I have plenty of experience with SQL Server and have built
some web apps with classic ASP but have never used ASP.NET before.

I have got as far as getting the text file from the workstation
uploaded to the webserver and now I need to execute a bulk insert to
load the file into a temporay table before calling a SP that I've
already written to process and import the data to production tables.

Can anyone point me in the right direction regarding getting ASP.NET to
do a bulk insert. I'm using VB as my ASP language.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,483
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top