Forum Discussion

Lenin Kumar P's avatar
Lenin Kumar P
Copper Contributor
Mar 16, 2018

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.

No RepliesBe the first to reply

Resources