Exporting Excel cell data to database via Excel macro?
Is it possible to create a macro written in C # for Excel that allows me to export cell data to a SQL Server or Access database?
Basically, I would like to create a button in Excel that stores data in specific cells in a database. It can be done?
Instead of creating a user interface from scratch for the program, I decided to use Excel as the user interface would be better for business needs.
0
source to share
1 answer
How to automate Excel using Visual C # to fill or retrieve data in a range using arrays would be a good starting point.
Keep in mind that you are having a hard time dealing with what people are trying to enter into an Excel sheet as the data flexibility of the inherited data works again with your attempts to write it to the database destination.
+1
source to share