You want to check from:
-
objDB.Execute _
-
"SELECT * INTO [Excel 8.0;DATABASE=" & strExcelFile & _
-
".[" & strWorksheet & "] FROM " & "[" & strTable & "]"
TO:
-
objDB.Execute _
-
"SELECT <<Name the fields that you want to select>> INTO [Excel 8.0;DATABASE=" & strExcelFile & _
-
".[" & strWorkSheet & "] FROM [" & strTable & "]"
Replace <<Name the fields that you want to select>> with the actual names of the fields that you want to export separating each field name with a comma ","
example
select Name, address, Phone From TableName
Hope that helps,
Joe P.