I currently have a database with the following schema:
Table: Articles Columns: ID, Title, Author, Content
Table: Authors Columns: ID, AuthorName, EmailAddress
Table: Categories Columns: ID, CategoryName
I'm interested in moving this over to WordPress. I do NOT actually need to preserve the authors or categories tables because we are revamping those sections in the migration. However I DO need to save certain rows (or all, if easier) of the articles table. This includes keeping the author ID linked to it. I'm willing to do manual queries in order to select which rows I want to move over to the new table, but I'm not sure exactly where I should do this. So my question is: How can I move these articles over to WordPress in the easiest, most seamless fashion?
Bonus points if I'm able to assign authors on import somehow.