Current recordset does not support updating vbscript Free live sex chatlines in usa
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. I have thought of following option: 1) Every 11 seconds, an Excel macro will run and will “Save as” excel as CSV file.
Execute "UPDATE tbl People SET Salary = Salary*1.03 WHERE Sex='F';" Current DB.
(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. Or do you have a better approach which requires less time to update the database? I found following links to be more useful: I hope this helps someone having similar problem as mine.
The examples that follow next do not show opening or closing recordsets since that is unnecessary for action queries.
There is also a small collection of SQL examples where you can see a wider variety of syntax.