I need to set the date format to based on the system locale and once I have captured the date, I will update it to a SQL Server Database with an unknown date format.
Hence I am thinking of doing the following:
commandvar="set dateformat ymd" + Chr(10) + "sp_updatesometable blar blar blar"
recordset.open commandvar, connectionobject
However, when I tried that, it gives error.
Please help! Thanks you in advance.
The command work in query analysier
The recordset.open works when the commandvar contain only one SQL statement