When it comes to inserting data quickly and with minimal impact to server performance, SQL Bulk Insert on average can load a database table in seconds. In my test runs, I was able to insert 700,000 ...

You should see the data listed (Figure A). Figure A Continue adding data to the table in the same fashion. And that’s all there is to creating a table and inserting data into it on MySQL.

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.