Correct Code Syntax - transferspreadsheet

[JungleJme]

Hi,

I'm trying to use the transferspreadsheet command but keeping getting an expression error. Can someone check my syntax and see where it is going wrong?

DoCmd.TransferSpreadsheet(acImport,,"tbl_temp_sql_data","C:\Users\7092\Documents\Master\Current Work\DB Folders\sqlexec.xls",TRUE,,)

Correct = TransferSpreadsheet(TransferType, SpreadsheetType, TableName, FileName, HasFieldNames, Range, UseOA)

Thanks

J

 

[vbaInet]

Remove the parentheses and the two trailing commas.