Does anyone know how to write a query so that I can take a table with 1.6 million rows and split it out into multiple tables of 65000 rows or less? I'm trying to do an APPEND query to another table and it gives a key violation, I'm assuming because of the number of rows.
Thanks. I use mysql a lot. Will just have to play around with ODBC connections with it. I figured out the problem with this particular issue. It was a problem where my primary key was not set to "auto number" so it was looking for a number to stick in there. I switched it and away we went.
I will look into using mysql for this project though. Thanks for the advice. C-