E
Emma
Hi all,
I was hoping someone could help me. When I run the following code I am
getting the above referenced error with 'Query must have at least one
destination field'. Why??? My table name is correct and it is a table, the
Specification name is correct:
Private Sub TransferFile_CmdBtn_Click()
msgbox "Would you Like to Start GPO Membership Transfer from CSV file?",
vbYesNoCancel
DoCmd.OpenQuery "Qry_Flush_GPO Membership table" ' remove existing
records from GPO_Memership table
GPO_Mbr = "C:\documents and settings\administrator\My
Documents\netmanage\Rumba\AS400\GPO_Members.csv" 'assign variable to
existing GPO Membership csv file
DoCmd.TransferText acImportDelim, "GPO_Members Import
Specification", "GPO_Membership", GPO_Mbr, False 'Transfer csv. file using
saved import specification to GPO Membership table
msgbox "GPO Membership File Transfer Complete", 0, "Transfer
Complete" 'Transfer was successful
End Sub
Thank you!!!!
I was hoping someone could help me. When I run the following code I am
getting the above referenced error with 'Query must have at least one
destination field'. Why??? My table name is correct and it is a table, the
Specification name is correct:
Private Sub TransferFile_CmdBtn_Click()
msgbox "Would you Like to Start GPO Membership Transfer from CSV file?",
vbYesNoCancel
DoCmd.OpenQuery "Qry_Flush_GPO Membership table" ' remove existing
records from GPO_Memership table
GPO_Mbr = "C:\documents and settings\administrator\My
Documents\netmanage\Rumba\AS400\GPO_Members.csv" 'assign variable to
existing GPO Membership csv file
DoCmd.TransferText acImportDelim, "GPO_Members Import
Specification", "GPO_Membership", GPO_Mbr, False 'Transfer csv. file using
saved import specification to GPO Membership table
msgbox "GPO Membership File Transfer Complete", 0, "Transfer
Complete" 'Transfer was successful
End Sub
Thank you!!!!