Transfer Spreadsheet method in visual basic

[edralyn]

hello everyone! i have a problem in coding for my system...i want to know how could i use the

Const transferDir = "c:\my documents\"
rangeName = "Companies"
tableName = "Companies"
DoCmd.RunSQL "delete from " & tableName
DoCmd.TransferSpreadsheet acImport, 8, tableName, _
transferDir & "OriginalData.xls", True, rangeName

i want this code to be transferred.. which i will not use SQL as my backend but MS Access....pleas e i need your help guys....thanks

[willakawill]

As you are using vba and access, I have moved your question to the access forum