Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rating: Thread Rating: 2 votes, 5.00 average. Display Modes
Old 07-31-2017, 07:49 AM   #31
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 12,236
Thanks: 92
Thanked 2,025 Times in 1,972 Posts
jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light
Re: Using/parsing JSON with vba

sxschech,

Do you then process the csv through individual/custom procedures/code to get normalized tables?
I just passed the json file from post 29 thru the online json -csv and got the attached.
I'm just curious at how you would process the csv within your Access.
Thanks

I changed the extension to txt
Attached Files
File Type: txt result.txt (1.4 KB, 29 views)

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
jdraw is offline   Reply With Quote
Old 07-31-2017, 08:10 AM   #32
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,997
Thanks: 114
Thanked 3,011 Times in 2,738 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Using/parsing JSON with vba

@jdraw

I also managed to lose my reply post

2 zip files attached each with 3 files
a) ImportedCalls - json => xlsx using Excel PowerQuery => Access
b) MultiSquad - json +> csv using online convcerter => Access

Multisquad proved more tricky as it had lots of empty fields - perhaps you chose it knowing that!
I had trouble using PowerQuery so I used the online converter

To import csv files into Access you just use 'Import From Text'

@sxszech
Out of interest why did you switch to the paid version of the converter?
Attached Files
File Type: zip ImportedCalls.zip (40.5 KB, 35 views)
File Type: zip MultiSquad_JED_json.zip (20.8 KB, 40 views)
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin (Mendip Data Systems)
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


"As we know, there are known knowns; there are things we know we know. We also know there are known unknowns; that is to say we know there are some things we do not know. But there are also unknown unknowns the ones we don't know we don't know. It is the latter category that tend to be the difficult ones" Donald Rumsfeld
isladogs is offline   Reply With Quote
Old 07-31-2017, 08:31 AM   #33
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 12,236
Thanks: 92
Thanked 2,025 Times in 1,972 Posts
jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light
Re: Using/parsing JSON with vba

No. Not empty fields. The original json has some arrays. In database normalized tables these would be separate tables with PK fields. With csv you make a table with 1 large record and show empty fields.
That was my concern with processing more complex json strings.

You have Squads, each Squad has Members, and each member has Powers.

A Squad has 1 or more Members.
A Member has 1 or more Powers.

Squad-->Member-->Power

Also in your Mutlisquad table note that
members__powers____001 and
members__powers__001 are similar names for different fields.
And from a database perspective, when you have repeating groups, you would design a separate table to achieve normalized structure.
Attached Images
File Type: jpg jsonSqads.jpg (53.9 KB, 102 views)

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by jdraw; 07-31-2017 at 08:37 AM.
jdraw is offline   Reply With Quote
Old 07-31-2017, 09:35 AM   #34
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,997
Thanks: 114
Thanked 3,011 Times in 2,738 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Using/parsing JSON with vba

Hi Jack

First of all apologies.
After losing my first reply, I rushed my second reply & misread your post.
You were asking how the csv file would be processed to create normalised tables - I misread that as how to import them - doh!

Anyway, I roughly got the same structure as your jpg file shows when I tried importing into Excel using PowerQuery.
It was a tricky example!



I didn't think you'd be happy with that so used the online converter to make a 'standard CSV file' - un-normalised but 'accurate' in terms of the source data
If it had been an XML file, Access would still have failed to split it correctly

I've also redone the original json100 import into Excel but this time keeping it as 100 records
Basically Excel allows you to choose how to do each step as you can hopefully see in the screenshot below

Attached Images
File Type: png ExcelJSONImportPNG.PNG (9.4 KB, 474 views)
File Type: jpg ImportJSON100.jpg (99.2 KB, 455 views)
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin (Mendip Data Systems)
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


"As we know, there are known knowns; there are things we know we know. We also know there are known unknowns; that is to say we know there are some things we do not know. But there are also unknown unknowns the ones we don't know we don't know. It is the latter category that tend to be the difficult ones" Donald Rumsfeld

Last edited by isladogs; 07-31-2017 at 09:57 AM.
isladogs is offline   Reply With Quote
Old 07-31-2017, 10:17 AM   #35
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 12,236
Thanks: 92
Thanked 2,025 Times in 1,972 Posts
jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light
Re: Using/parsing JSON with vba

Colin,

No apologies needed. Most of the examples I've seen have a fairly straight forward object with no array(s). That's the reason for this latest json ---more realistic example (and it may not have some json peculiarities).

The JsonToAccess routine I found builds 1 table. It does keep array info intact in a single field for each array it finds. I wrote a small routine to review those fields (with multiple values) and create separate tables. However, you have to know the structure of the json (part of the schema) in order to create those related tables.

It looks to me that the multiple ip addresses (and emails) in your example have just been concatenated together??
In my view they should be separate fields in a new table that also included the ID field from the generated table.

I appreciate your efforts and comments.

As for JsonToAccess I did send an email to the author for more info. No reply yet on details.
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
jdraw is offline   Reply With Quote
Old 07-31-2017, 01:27 PM   #36
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 11,333
Thanks: 40
Thanked 3,670 Times in 3,538 Posts
CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light
Re: Using/parsing JSON with vba

late to the party, working away at the moment

@ridders to clarify this comment
Quote:
approach makes the system vulnerable in some cases, since it allows the direct access to the drives (and other stuff) for the malicious JS code via ActiveX's
refers to using the json.parse function using scriptcontrol
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Old 07-31-2017, 05:37 PM   #37
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 12,236
Thanks: 92
Thanked 2,025 Times in 1,972 Posts
jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light
Re: Using/parsing JSON with vba

I have lost another post??? retyping from memory...

I want to update the thread to say that the JsonToAccess utility mentioned earlier failed during the conversion when I tried to use the MultiSquad_Jed.json file. It didn't matter what sublevel I used, it failed each time.
I did send an email to the author/supplier questioning the routine and asked specifically if he could process the file. I suggested the routine may not be able to handle array(s) adequately. Similar for the DataFileConverter, as below.

I also tried his DataFileConverter to convert the MultiSquad_JED.json rom json to csv, and also jon to sql -- the conversion did not fail with error, but the output was not sufficient to import into Access.
It left [] as field name when it met the second array?? On the second element of the outer array it gave me over 20 fields???

UPDATE Aug1
I got a response from the author/supplier of JsonToAccess/DataFileConverter. They will work with the json file and let me know.

Further Update: The company returned my json file with a modification. I'm trying to attach it here, but for some reason can not get Manage Attachments to work?? However, both my original and the modified version passed the json validator/viewer on Notepad++. Neither my original not the revised version of the json (with embedded arrays) were converted successfully. See comments at the end of post #43.

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by jdraw; 08-01-2017 at 03:24 PM. Reason: additional info
jdraw is offline   Reply With Quote
Old 07-31-2017, 08:15 PM   #38
sxschech
Newly Registered User
 
Join Date: Mar 2010
Posts: 611
Thanks: 28
Thanked 112 Times in 101 Posts
sxschech is on a distinguished road
Re: Using/parsing JSON with vba

Regarding the data, I do run the data through some loops, recordsets and temp tables to remove the excess underscores of field names as well as to "fill in the blanks" and get the data into a usable format. Still an effort, but the json-csv conversion is one less headache than trying to figure out the json translation on my own. Before I had the desktop version, I used vba and an excel macro to have one keystroke to paste json string into the browser. After it translated and browser asked to open or save excel, I choose open and ran a macro to fix headers, columns then select and copy all the data to paste into the access table (datasheet form) opened by vba so that I didn't have to spend time saving and importing. The data we are getting is from Survey Monkey and it took quite a while to understand the relationships in their data in order reassemble it in a layout that access and sql could handle. In a few cases where I only needed one or two elements, I used string functions to pull the data directly out of the json string rather than go through the conversion.
sxschech is online now   Reply With Quote
Old 08-01-2017, 12:20 AM   #39
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,997
Thanks: 114
Thanked 3,011 Times in 2,738 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Using/parsing JSON with vba

Reading sxszech's reply, that process is used for a data from a single source.

If the source is changed, a new set of rules would be required.
A bit like the import specifications but in multiple steps.

Essentially that's what PowerQuery does and the steps can be saved

@sxszech
Would you mind trying that excel addin on your JSON data and see if it works for you
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin (Mendip Data Systems)
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


"As we know, there are known knowns; there are things we know we know. We also know there are known unknowns; that is to say we know there are some things we do not know. But there are also unknown unknowns the ones we don't know we don't know. It is the latter category that tend to be the difficult ones" Donald Rumsfeld
isladogs is offline   Reply With Quote
Old 08-01-2017, 07:16 AM   #40
sxschech
Newly Registered User
 
Join Date: Mar 2010
Posts: 611
Thanks: 28
Thanked 112 Times in 101 Posts
sxschech is on a distinguished road
Re: Using/parsing JSON with vba

ridders are you suggesting I try excel power query on the json? If so, I had tried installing power query for excel 2013 some time ago, for a different purpose and it caused problems locking up excel and had to use task manager to close excel, so I uninstalled it.
sxschech is online now   Reply With Quote
Old 08-01-2017, 07:22 AM   #41
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,997
Thanks: 114
Thanked 3,011 Times in 2,738 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Using/parsing JSON with vba

That was my suggestion.
It runs without issues for me in Excel 2010 and is meant for 2013 as well.
20160 has Get & Transform instead which has additional functionality.
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin (Mendip Data Systems)
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


"As we know, there are known knowns; there are things we know we know. We also know there are known unknowns; that is to say we know there are some things we do not know. But there are also unknown unknowns the ones we don't know we don't know. It is the latter category that tend to be the difficult ones" Donald Rumsfeld
isladogs is offline   Reply With Quote
Old 08-01-2017, 07:51 AM   #42
sxschech
Newly Registered User
 
Join Date: Mar 2010
Posts: 611
Thanks: 28
Thanked 112 Times in 101 Posts
sxschech is on a distinguished road
Re: Using/parsing JSON with vba

I'll see if I can block out some time later this week to give it a go.
sxschech is online now   Reply With Quote
Old 08-01-2017, 01:34 PM   #43
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 12,236
Thanks: 92
Thanked 2,025 Times in 1,972 Posts
jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light
Re: Using/parsing JSON with vba

Having looked at a variety of Json-Access articles and some code, I can now see that although there is a structure to json,
there is no data that directly relates to table column, related table as we have in database. What the various converters do
is very dependent on the json string(file) supplied. This is especially true when you have arrays and embedded arrays in the
json.Many json to csv will give a field per every field in every record.
The json to text test in the xlsm example at vba JSON parser example xlsm from
https://github.com/omegastripes/VBA-...arser/releases by omegastripes@yandex.ru is worth
investigating if you need to parse json and have Excel familiarity.

Various json to csv converters work well if the json is fairly simple --no embedded arrays (at least that's what I have found and
I admit to little knowledge of json and Excel).

The jsonToAccess utility (Shiji Pan at https://www.withdata.com/jsontoaccess/download.html) can work well with simple json
with a little manipulation (no embedded arrays) and handles multiple single arrays (that is not embedded). Shiji did respond to my
email request, but I find the material lacks documentation for the average user. There is a cost for the routine ~$50 US. He offers
other converters (for a fee) --I tried the DataFileConverter and found that it did not process the sample json file with embedded
arrays ( a somewhat complex structure).

The regex json parser by omegastripes@yandex.ru at Stack Overflow seems to be the most professional and thorough routine,
but it is not designed to create Access tables. However, I think it is a base that a "programmer" could evolve/adapt.
In my limited tests (and knowledge) it certainly handles embedded arrays etc. and claims the parser to be based on a json standard.

I am still looking for sample data from peskywinnets whose post got me interested in looking at ways to handle webservice
responses in json format with Access and vba.

Ridders and sxschech have offered some other routines/methods.

PS: I have attached the modified json file MultiSquad_JED_Modified_json.txt. My original MultiSquad_JED.json was modified by the supplier of the JsonToAccess utility mentioned earlier in this thread. Both versions of that file passed the json validator/viewer, but neither was successfully processed by the JsonToAccess utility.
Had to change the extension in order to attach it here.
Attached Files
File Type: txt MultiSquad_JED_modified_json.txt (1.4 KB, 21 views)
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by jdraw; 08-01-2017 at 03:21 PM.
jdraw is offline   Reply With Quote
Old 08-01-2017, 05:43 PM   #44
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,997
Thanks: 114
Thanked 3,011 Times in 2,738 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Using/parsing JSON with vba

Hi again

Previously when I used Excel to import JSON files, all I was trying to do was get all the data into 1 table - so it wasn't normalised

I've just had another go at converting the two JSON files into normalised data in Excel & which can then be imported direct into Access tables.

a) The original JSON100 was converted using Excel 2010 PowerQuery into 3 'tables' i.e. worksheets

b) The modified MultiSquad JSON was converted using Excel 2016 Get & Transform Data into 3 'tables'

I didn't use any code or other converters
All done in Excel & then imported to Access.
I'm not yet proficient with this but I'm getting there

See the attached files and let me know what you think.

Each zip file contains JSON, XLSX & ACCDB versions
Attached Files
File Type: zip MultisquadJEDModified.zip (48.2 KB, 31 views)
File Type: zip JSON100Normalised.zip (73.3 KB, 31 views)
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin (Mendip Data Systems)
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


"As we know, there are known knowns; there are things we know we know. We also know there are known unknowns; that is to say we know there are some things we do not know. But there are also unknown unknowns the ones we don't know we don't know. It is the latter category that tend to be the difficult ones" Donald Rumsfeld
isladogs is offline   Reply With Quote
Old 08-02-2017, 10:10 AM   #45
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 10,314
Thanks: 537
Thanked 940 Times in 891 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: Using/parsing JSON with vba

This is in reply to jdraw in another thread.

Hi Jack, Yes I have been following the thread. (As in This Thread) I have a web development use for just such a Class. I export a web page created in Elementor, (a WordPress page builder) and it's in a very complicated looking JSON file. I have hundreds of YouTube videos that I need to add to my website.

I'd like to automatically replace the YouTube links, YouTube video names, description and the like in the exported template and then load the template back into WordPress. There is a JSON Class module for Excel somewhere. A few years back, I did make a feeble attempt at adapting it for use in Access, but couldn't make it work, and gave up. It might be worth another look, as in two heads are better than one, so what might happen if a forum full of heads looked at it?

BTW I'm sort of out of the Access picture for a couple of weeks as I'm looking after me mum, as she's broken her ankle! I still drop in here via "mobile" occasionally!

Sent from my SM-G925F using Tapatalk

__________________
Code:
                 |||||
               @(~^~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)

Last edited by Uncle Gizmo; 08-02-2017 at 11:39 AM.
Uncle Gizmo is offline   Reply With Quote
Reply

Tags
json , vba access

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Paypal API returned data is JSON - how do I parse? peskywinnets Modules & VBA 4 10-27-2016 12:59 AM
downloading a JSON file and updating database Cowboy_BeBa Modules & VBA 1 03-23-2016 02:20 AM
Import table to access 2003 database from json file MBMSOFT Visual Basic 1 05-16-2015 02:46 PM
Convert JSon data string to readable data eatraas Modules & VBA 4 06-02-2014 09:15 AM
Parsing XML haydenal Modules & VBA 7 10-19-2009 12:50 PM




All times are GMT -8. The time now is 09:14 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World