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

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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