With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.
I'm just looking for a simple method to get the dataset into a blank access database.
Dim objDataSet As DataSet objDataSet = New DataSet Dim FileSpec As String = "*.xml" For Each foundFile As String In My.Computer.FileSystem.GetFiles(SourceFolder & "\", _ FileIO.SearchOption.SearchTopLevelOnly, FileSpec) objDataSet.ReadXml(foundFile) Dim objDataTable As DataTable For Each objDataTable In objDataSet.Tables objDataTable.BeginLoadData() Next objDataSet.ReadXml(foundFile) For Each objDataTable In objDataSet.Tables objDataTable.EndLoadData() Next Next Dim MBData As String = objDataSet.Tables.Count & " Tables Created" & vbCrLf For Each table In objDataSet.Tables MBData += "Table = " & table.TableName & _ " - Row Count = " & table.rows.count & _ " - Column Count = " & table.columns.count & vbCrLf Next table MessageBox.Show(MBData)
Join the community of 500,000 technology professionals and ask your questions.