Import Not working (1 Viewer)

Locopete99

Registered User.
Local time
Today, 14:12
Joined
Jul 11, 2016
Messages
163
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

Code:
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

AWF VIP
Local time
Today, 13:12
Joined
Mar 9, 2014
Messages
5,470
Code works for me. If you want to provide workbook for analysis, follow instructions at bottom of my post.
 

Users who are viewing this thread

Top Bottom