Thank you all for your comments. Thus far, I have still not been able to get my new data into my table. I tried all of your suggestions, but they all result in the more or less the same as mine did. No new data ended up in my table. I know I'm on the right track though because if I limit my SQL to just adding data to one field, it works flawlessly. Wierd. Anyway, thanks for your help, I'm sure I'll be needing more tomorrow :-) lucky you. -Dave