victornegri
asked on
Excel post to SQL
I would like to know if there's a way for Excel to post something to an ASP web page that in turn makes modifications to a MSSQL2000 db.
Here's the story: A client wants to have data pulled from the db through asp to Excel. I would like to in turn, send some data back to the SQL db stating that something has been completed on the Excel sheet (i.e. change status to "Shipped" or "Pending").
URLs or samples would be excellent!
Here's the story: A client wants to have data pulled from the db through asp to Excel. I would like to in turn, send some data back to the SQL db stating that something has been completed on the Excel sheet (i.e. change status to "Shipped" or "Pending").
URLs or samples would be excellent!
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Oh, as for the security portion, use https and send your username and password or a session id as one of the name/valuepairs
Yes, I know it looks easy to hack, welcome to the web. (PS Thats why I suggested https)
Cheers,
-Bill
Yes, I know it looks easy to hack, welcome to the web. (PS Thats why I suggested https)
Cheers,
-Bill
ASKER
Cool... thanks. I'll try it out.
Programming
Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.
55K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER