How to Import Data?

I have some data (journal) that I have tried to import into WP. The table is pretty basic, with fields like entry date, journal_text, category etc and so I started by creating the same categories in WP as were used for the journal. I can import the data just fine into the wp_posts table, and although the post_category field is populated with the correct category numbers, and the posts show up fine.But the categories do not show up so I am betting there are some other tables that need to be populated. Can someone suggest how I can import some data from another table, into the wp_posts table and also populate any cooresponding tables/data so the categories listed in wp_posts show up properly? This is the sql I am using for the import…..the “j_entries” table is the table containing the old journal entries.

insert into wp_posts (ID, post_author, post_date, post_date_gmt, post_content, post_title, post_category, post_excerpt, post_status, comment_status, ping_status, post_password, post_name, to_ping, pinged, post_modified, post_modified_gmt, post_content_filtered, post_parent, guid, menu_order, post_type, post_mime_type, comment_count)

select ”, 2, Edate, Edate, Etext, Etitle, catID, ”,’publish’,’open’,’open’,”,”,”,”, Edate, Edate,”,0,”,0,’post’,”,”
from j_entries
where eid=1;