424,066 Members | 2,123 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,066 IT Pros & Developers. It's quick & easy.

Excel Sheet data into multiple SQL database tables.

P: n/a
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!
Nov 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"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

Nov 20 '05 #2

P: n/a
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!

Nov 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.