Lenin Kumar P
Mar 16, 2018Copper Contributor
Transfer Data from Excel to Access using Docmd.Transferspreadsheet
Hi
I am trying to transfer the data from a excel sheet or multiple sheets to access. when I try to use the below method getting Error 450 Wrong number of arguements or invalid property assigned. Note : first I was using early binding the same command works fine. but later changed to late binding coz of Library reference getting the above said error.
DB.DoCmd.TransferSpreadsheet TransferType:=0, SpreadSheetType:=10, TableName:=a, Filename:=wspath, HasFieldNames:=True
any suggestions would be appreciated.