I have try it whit import/export but it only allows 100 rows.

But what tool shoed i use to insert 1000 rows?

Thnx/Tack

This is the values i got from my teacher to insert...

is it wrong values or is it something wrong whit me?

pers_idchef_idlönekategoriförnamnefternamnTitel

1341Johan ...

when i drop all my tables and recreat them and insert whit this...

Insert into personal (chef_id,lonekat_id,fornamn,efternamn,titel)

VALUES (NULL,1,'Johan','Forsberg','Säljare');

Then the personal_id on personal get the value of 3

what does this mean?

Insert into personal (chef_id,lonekat_id,fornamn,efternamn,titel)

VALUES (34,1,'Johan','Forsberg','Säljare');

Msg 547, Level 16, State 0, Line 1

The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK__personal__chef_i__2645B050". The conflict occurred in database "Gangster", table...

i tested it but it doesnt work.. its starts with 51.52.53,54

Msg 4712, Level 16, State 1, Line 1

Cannot truncate table 'lonekat' because it is being referenced by a...