When i try to run a macro from Access : Runcode Function name mine()
I get the compile error
Here is my module
Public Function mine()
Sub InsertData()
DoCmd.TransferText transfertype:=acImportDelim, _
specificationname:="CATS Spec", _
tablename:="CATS D", _
filename:="C:\Users\GrahamS4\Desktop\CATS.csv", _
hasfieldnames:=True
End Sub
End Function
As you can see i have the end function. Why do i get this error?