Hey guys,
I'm importing an excel file using vba. I'm getting a type conversion failure due to one field setting set to number instead of text. I'm looking for a code to set the data type of one field to text instead of the default (number). Here is my code if that helps.
Code:
Public Function EXCELIMPORT()
Call DoCmd.TransferSpreadsheet(acImport, acSpreadsheetTypeExcel9, _
"SHEET1", "C:\Users\198657\Documents\OUTLOOK ATTACHMENTS\AR DAILY\AR DAILY " _
& Format(Date - 1, "m-d-YYYY") & ".xlsx", True)
MsgBox "IMPORT SUCCESSFUL"
End Function
Thanks!