Exporting Excel cell data to database via Excel macro?

Question

Can I create a macro written in C# for Excel that allows me to export a cell's data to a SQL Server or Access database?

Basically, I'd like to create a button in Excel that saves the data in certain cells to a database. Can this be done?

Instead of creating a UI from scratch for a program, I've decided using Excel as the user environment would be better for business needs.

Does it have to be written in C#? Aren't macros in Excel typically written in VBA? — Tim C
– Tim C, Commented Dec 24, 2008 at 8:26

Derek B. Bell · Accepted Answer · 2008-12-24 13:22:09Z

1

How to automate Excel by using Visual C# to fill or to obtain data in a range by using arrays would be a good starting point.

Be aware, you're going to find it frustrating to control what people attempt to enter into the Excel sheet, as the inherit flexibility of the data works again your efforts to write it to a database destination.

answered Dec 24, 2008 at 13:22

Derek B. Bell

3192 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Exporting Excel cell data to database via Excel macro?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related