Can I add posts in PHP myAdmin

Did a search on this but cant find anything specific to what I’m trying to do.

I want to add several hundred posts that are identical except for a few titles and links. I know I can duplicate a post and change the data/text but would be much faster if I do in a spreadsheet and save as CSV then import to the table.

I tried this by exporting the table as CSV – changed the data with a new ID and then imported back into myAdmin. It says the import was successful but I dont see it in the table and its not posted in the blog.

Just wondering if I’m doing something wrong or if theres a better way to do this. ANy suggestions would be great.

Thanks