Keyboard macros are great. C-x ( to start recording, C-x ) to finish, C-x e to execute. You can also do Meta-999 C-x e, which will execute your macro 999 times (or until it reaches the end of the file). It's great for turning, say, a CSV file into a sed script.
Or into a list of insert statements if you're too lazy to read up on how to use sqlldr.
Or into a list of insert statements if you're too lazy to read up on how to use sqlldr.