Button to transfer data from Excel to SQL

[Shin25]

Hi All

Iam looking to find out is it possible to create like a button in MS Excel 2003 that transfers information from a workbook with multiple worksheets into a sql db. The information will be stored in pre-defined worksheets/cells for automation purposes....

Anyone any ideas?

 

[xlbo]

Yes - as I replied before. Try something. Look on google / search here / look in excel files for "ADO". There are loads of examples on this site that will help you get going.

When you hit a problem or something doesn't work, post here with the code, a detailed explanation of what you have tried and what is not working

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question