db.docmd.transfersheet

[Lenin Kumar]

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.

 

[Hui]

Lenin

Firstly, Welcome to the Chandoo.org Forums

Your post has been cross-posted, which means it has been seen on other websites. This is considered poor practice, as it can waste peoples time, which could be spent elsewhere, especially if you get a solution and don't notify us.

I encourage you to please read the site rules at:
http://forum.chandoo.org/link-forums/new-users-please-read.17/

 

[Lenin Kumar]

How to remove the cross post this is the first time I am posting on a forum

 

[Hui]

No need to remove it,
Just let people know that you have cross posted and if you get a solution, post it everywhere you have asked.

 

[Hui]

In regards your question, are you able to share the file ?