How to Import Multiple Spreadsheets Into Access. Microsoft Access supports direct import of spreadsheet data from files you've created in Microsoft Excel or saved as XLS or XLSX files in another ...

ExitSub: Exit Sub errorHandler: MsgBox "The File you tried to import was not an excel spreadsheet" Me.txtFilename = vbNullString Resume ExitSub End Sub 'This function add Public Sub ...

I don't know anything about using the VBA tools in Access or whatever, but the JSON text that you included doesn't parse properly in any of the online validators or beautifiers that I pasted it into ...