search

VBA-tools / VBA-JSON

JSON conversion and parsing for VBA
MIT License
1.74k stars 566 forks source link

Make all JSON item as string #225

Open azmirzakaria opened 2 years ago

azmirzakaria commented 2 years ago

How can I make all JSON item as string instead of based on excel column type. I need to do this because when I tried to upload the dara to MySQL, it will not be able to upload JSON data with non string type.

houghtonap commented 2 years ago
  1. When you say you upload the data to MySQL, how do you accomplish that? For example, do you write the Excel worksheet to a CSV file, then run a CSV import on the MySQL side with a query or do you use the MySQL for Excel plugin?
  2. Can you attach a small Excel document with some data. Nothing large, 10-20 rows would be sufficient.
  3. What is the MySQL database schema that you are using. A table of column names and their data types and lengths would be sufficient.
  4. What is JSON schema that you are using or would like to generate from the Excel columns in the worksheet.

Hopefully we can figure out a solution for you.