Import Not working

[Locopete99]

Hi Guys,

I have an import statement that doesnt seem to be working

I have a table : Tbl_Debt
import sheet: import.xlsm
import range: Import

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "tbl_debt", "R:\In box management project\Media\import.xlsm", True, "import"

All the headers on the import sheet match the field names of the table.

But, it runs and doesnt Import.

 

[June7]

Code works for me. If you want to provide workbook for analysis, follow instructions at bottom of my post.