Appending to Existing Table

[tbaxter]

I have a "contact" database that needs to be updated on a regular basis with information that I download in .csv format and save into Excel format. I'm trying to expedite the transfer of data from the spreadsheet to my database so I don't have to enter each contact individually (which is how I've been doing it).

The basic table structure is as follows:

ID - Autonum
Last - Text
First - Text
Address - Text

etc.

I import the spreadsheet into Access into my "Append Table" which has the same structure except that the ID field is assigned as a number (long integer).

I developed an Append Query to append the Append Table to the Contact Listing Table but when I try to execute the query I get the following error: "You tried to assign the null value to a variable that is not a Variant data type."

Is this because of the AutoNumbered field? How can I fix it so that it will append the records and assign the next "autonum" for each new record.

This is probably really basic and I do apologize if it is but my brain doesn't seem to be engaging today . . . Any and all help will be appreciated!

Tina

 

[tbaxter]

Hi all,

I found the solution and wanted to post it here rather than delete the original message in case anyone else had the same problem. After doing some digging, I realized that I needed to get rid of the ID field in the Append table. I did that and it worked perfectly!

Tina