How to update MYSQL Database with data from Excel using ASP.NET?

Question

I have an excel file which gets updated every 10 seconds through an automated process. I need excel data to be updated in MY-SQL database which is located on a remote server.

How do I do that?

I have thought of following option: 1) Every 11 seconds, an Excel macro will run and will "Save as" excel as CSV file. (not sure whether this can be done by macro...just thinking) 2) This CSV file we will FTP to remote server using Windows Service. 3) On remote server, we will parse the csv file and Update MYSQL database.

Is this approach fine? Or do you have a better approach which requires less time to update the database?

Thanks!

Do you have any options to modify the automated process with the excel file? — mellamokb
– mellamokb, Commented Mar 4, 2011 at 5:13
@Mellamokb, Excel basically fetches data from a third party server...so what options do you think we should modify in that excel? — meetpd
– meetpd, Commented Mar 4, 2011 at 5:15
For instance, can your remote server with MySql query the same third-party server directly, instead of passing through with Excel file. — mellamokb
– mellamokb, Commented Mar 4, 2011 at 5:17
That's a good idea. But unfortunately no. That third party service has an Excel plugin. So they only allow data access thru Excel :( — meetpd
– meetpd, Commented Mar 4, 2011 at 5:22

meetpd · Accepted Answer · 2011-03-19 04:14:27Z

1

I found following links to be more useful:

http://www.heritage-tech.net/908/inserting-data-into-mysql-from-excel-using-vba/

http://vbaexcel.eu/vba-macro-code/update-mysql-database-php

I hope this helps someone having similar problem as mine.

answered Mar 19, 2011 at 4:14

meetpd

9,24921 gold badges74 silver badges120 bronze badges

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

Comments

mellamokb · Accepted Answer · 2011-03-04 05:18:30Z

0

You can connect to the Excel spreadsheet using ODBC connection, read the data, and post it to the MySQL database, maybe through some sort of web service access, or via a saved CSV file?

edited Mar 4, 2011 at 5:18

answered Mar 4, 2011 at 5:13

mellamokb

56.8k12 gold badges111 silver badges138 bronze badges

Collectives™ on Stack Overflow

How to update MYSQL Database with data from Excel using ASP.NET?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related