Avatar of aeolianje
Flag for United States of America

asked on 

Transferspreadsheet 31519 error

I am trying to import an Excel .xlsx file into Access using VB code and receive a 31519 error ("You can not import this file") followed by error 424 ("Object required")

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "table name", GetFile, True

GetFile = the Excel file name

What am I missing?

thanks for your help
Microsoft Access

Avatar of undefined
Last Comment

8/22/2022 - Mon