If your database is BLANK, then you cannot use an UPDATE statement....Originally posted by TheWhiteKnight@May 19 2005, 11:25 PM
Well this IS a blank DB that I am testing it on. I wonder why it is coming back with nothing. Hmmm.... It should be putting the info into the DB instead of returning nothing. It's pulling that info straight out of the Excel sheet too.
INSERT statements ADD records to the database.
UPDATE statements, well, they update EXISTING information.
Perhaps you're looking at the wrong set of statements in your spreadsheet for what you're trying to do...