I am trying to use the following code to export specific table data from an Access 2010 database to the user's desktop. But I don't know how to change the code to make it export a specific table data (which will have just one record always). Can someone help?
Dim StrFileName As String
Dim fd As FileDialog
Dim vrtSelectedItem As Variant
Set fd = Application.FileDialog(msoFileDialogFilePicker)
.InitialFileName = "c:\sample\*.xml"
If .Show = -1 Then
For Each vrtSelectedItem In .SelectedItems
Set fd = Nothing