Are you sure you don't mean

INSERT INTO phonebook SELECT

[phonenumber],

[firstname] ,

[lastname] ,

[company]

FROM #tmp

DROP TABLE #Tmp

at the end