json to ms access table
'example form stackoverflow
'https://stackoverflow.com/questions/59301919/iteration-from-json-format-data-to-ms-access-table
Private Sub StoreData(ADataObject As Object)
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim item As Object
Set db = CurrentDb
Set rs = db.OpenRecordset("tblEfdReceipts")
For Each item In ADataObject
rs.AddNew
rs![TAX] = item("TAX")
rs![TaxpayerName] = item("TaxpayerName")
rs![Address] = item("Address")
rs![DateTime] = item("DateTime")
rs![TerminalID] = item("TerminalID")
rs![InvoiceCode] = item("InvoiceCode")
rs![InvoiceNumber] = item("InvoiceCode")
rs![SpecialCode] = item("SpecialCode")
rs![TelephoneNumber] = item("TelephoneNumber")
rs![Operator] = item("Operator")
rs![Taxlabel] = item("TaxItems")("TaxLabel")
rs![CategoryName] = item("TaxItems")("CategoryName")
rs![Rate] = item("TaxItems")("Rate")
rs![TaxAmount] = item("TaxItems")("TaxAmount")
rs![VerificationUrl] = item("TaxItems")("VerificationUrl")
rs.Update
Next item
rs.Close
Set rs = Nothing
Set db = Nothing
Also in JavaScript:
- populate DataTable from django json
- javascript Bingo add called number to a list
- dom ready js
- jstl expects equals
- returned value by findOneAndUpdate
- compare two arrays javascript
- how to check record successfully delete in mongodb node js
- enzynme not support react 17
- prepen an element js
- remove whitespace javascript
- doughnut chart.js chart go away when no values
- c# json from file to object
- react js image path src from local folder
- capturar el valor de un input con jquery
- codemirror get value
- iterate array in javascrpt
- json decode android
- how to check no internet connection in jquery mobile phone
- requestAnimationFrame without loss context angualar
- store data in localstorage javascript
- javascript get filename from url
- feathersjs mysql example
- remove item at index in array javascript
- angular get current time