SW2016 sp5

2010 excel

Trying to import excel file into machining/structural member table without success.

I exported the table then added rows as needed using exported formatting to add new material, but receive an error "syntax mismatch or incomplete information".

Import seems to work if I only modify existing info but cannot add rows, (need to add hundreds).

I have added the appropriate library items that correspond to the table items.