It should be noted that for this to work the third party library JSON.NET needs to be used and an ‘Imports’ statement must be added for ‘Newtonsoft.Json’.
Feedback is provided as to the success or failure of the task. The contents of the file is then constructed. If it does, a query is executed to extract the data from the database and if data is returned, the JSON file is opened for writing. JSON or JavaScript Object Notation files are an alternative file format to CSV, that can sometimes be used for both of these scenarios.īelow is an example of how Visual Basic can be used to export data to a JSON file called ‘personexport.json’, from an SQL Server database table called ‘person’, which was used in the examples for selecting, inserting, updating, deleting, importing and exporting data to CSV and XML formats.įirstly, a connection to the database is established, the JSON file path and name are set and a check is made to see if the path actually exists.
Sometimes it can be useful to export data from a database, so that it can be analysed, or, to import in to another computer system. Visual Basic and SQL Server – Exporting Data (JSON)
0 kommentar(er)
