[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 257
  • 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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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