Excel Sheet data into multiple SQL database tables.

  • Thread starter Thread starter Patrick B.
  • Start date Start date
P

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/understanding/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!
 
Patrick B. said:
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!
Click to expand...

Why not ask in a VBA group?
 
If you are interested I can be retained to help you with this problem.

(e-mail address removed)

remove the nospamhere part.
 
Back
Top