SQL -Import records into table with auto ID field
Posted on 2010-08-23
I have a list of emails that I want to import into an table that already has records with a auto ID field. I just want the auto ID field to assign a number just like it does when one email is added through the form. What syntax to I add to the SQL INSERT INTO statement to do that without messing up the data in the table. The fields are ID, email and date and the table can be called table.
Any help is appreciated,