Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 260
  • Last Modified:

ASP-Excel Add, Update and Delete rows code

Hi,

Does any one have the sample code for ASP Excel coonectivity with Add, Update and Delete rows functionality ???

Pls guide me.

Rgds,

Sumit Shah.
0
sumitshahmphasis
Asked:
sumitshahmphasis
  • 2
  • 2
1 Solution
 
SlimshaneeyCommented:
This might help.... You need to think of Excel in terms of being like a database. So, in essence, with the right connection string (look on www.connectionstrings.com), ado can talk and query excel like any other database.

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q195/9/51.ASP&NoWebContent=1
0
 
thefritterfatboyCommented:
To query an Excel workbook, however - I believe you must define a name. this is done by selecting the table area, hitting insert >> name >> define.
0
 
SlimshaneeyCommented:
You dont really. You can query a sheet like this without defingin a name

Select * from [Sheet1$]
0
 
thefritterfatboyCommented:
Is the $ necessary? If so then that's where I've been going wrong for so long!
0
 
masirofCommented:
No comment has been added to this question in more than 21 days, so it is now classified as abandoned..
I will leave the following recommendation for this question in the Cleanup topic area:
Accept: Slimshaneey

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

masirof
EE Cleanup Volunteer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now