no more than 5000 records

I want to insert 31102 records. Why does it hold no more than 5000 records?

Just have a look at the very top, there is a "spin-editor", which is calculating this LIMIT for the datagrid so you don't load a too large amount of data over the net. Your table is not cut. I always thought this is obvious enough...

oh ok. I'm adapting from MS Access 2000. That was something I wouldn't expect. There are probably so many tools added that could be useful. But for even MS Access 2000 I've seen people do so many things which until today I cannot figure out like coding SELECT statements in the db itself that will automatically create another table. That I would like to learn.

Oh and how do I set a primary key for id. Do I need to insert the id column from the MS Access 2000? or can Heidi create it automatically?

You can use the field- and index-editor in HeidiSQL to create a primary or other key. Just doubleclick a fieldname in the "Table" tab and there we go.

ok thanks