As Nelsona said, its best to take it via US designated ports of entry's like Fort Erie etc. In both my TN's, I got my TN in the morning at Fort Erie, spent sometime in Buffalo & Rochester and drove back in the afternoon. When asked in the Canadian border, I explained I had come for US TN visa.