Excel Sheet data into multiple SQL database tables.

[Patrick B.]

I have an existing excel spreadsheet that my customers
MUST continue using. There are 5 different specially
formatted cell groups (tables) on one sheet where the use
can enter data. The data in each of these "tables"
corresponds to a different table in a SQL database. What
is the quickest way for me to capture the click event of a
button on that sheet and move the data into my SQL
database tables? I have tried VBA and also the sample
discussed here:

http://www.msdn.microsoft.com/office...nding/excel/wa
lkthroughs/default.aspx?pull=/library/en-
us/odc_vsto2003_ta/html/odc_vstsqlexcl.asp

but cannot get either to work.

Is it even possible to access a SQL database using Excel
VBA? If not, is there any way to capture the button click
event of a button on the worksheet (using the method
described in the article)? If I could get the button
click event of a button on the sheet, I think I could get
the rest working. Thanks in advance for help!

[Armin Zingler]

"Patrick B." <an*******@discussions.microsoft.com> schrieb

Is it even possible to access a SQL database using Excel
VBA? If not, is there any way to capture the button click
event of a button on the worksheet (using the method
described in the article)? If I could get the button
click event of a button on the sheet, I think I could get
the rest working. Thanks in advance for help!

Why not ask in a VBA group?
--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

[scorpion53061]

If you are interested I can be retained to help you with this problem.

kj***********@charter.net

remove the nospamhere part.

"Patrick B." <an*******@discussions.microsoft.com> wrote in message
news:02****************************@phx.gbl...

I have an existing excel spreadsheet that my customers
MUST continue using. There are 5 different specially
formatted cell groups (tables) on one sheet where the use
can enter data. The data in each of these "tables"
corresponds to a different table in a SQL database. What
is the quickest way for me to capture the click event of a
button on that sheet and move the data into my SQL
database tables? I have tried VBA and also the sample
discussed here:

http://www.msdn.microsoft.com/office...nding/excel/wa
lkthroughs/default.aspx?pull=/library/en-
us/odc_vsto2003_ta/html/odc_vstsqlexcl.asp

but cannot get either to work.

Is it even possible to access a SQL database using Excel
VBA? If not, is there any way to capture the button click
event of a button on the worksheet (using the method
described in the article)? If I could get the button
click event of a button on the sheet, I think I could get
the rest working. Thanks in advance for help!