Avatar of marky102
marky102
 asked on

web service

how do i go about writing a .csv excel file 2007 data to sql2008 using a web service ?

what is the best approach ?
ASP.NETScripting LanguagesWeb Languages and Standards

Avatar of undefined
Last Comment
marky102

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
OriNetworks

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
marky102

ASKER
i would like to upload a file to a web server, and use the upload command, and not write to file. it is easy to do in an asp project or c# project, but i would like to do it in a web service.
OriNetworks

So you want to send the service the file and have the service write the records to the database?

If that is the case then just use the code from a regular asp.net project that does this and use it in the service. Consume the service from your application and pass the file stream as the input for the service. If you expect to work with very large files things will be a lot trickier.
marky102

ASKER
good approach
Your help has saved me hundreds of hours of internet surfing.
fblack61