Gang,

I use the current code to insert data from my workbook in to a table in my SQL2000 database:

Please Login or Register  to view this content.
In it's current form, if the user of the spreadsheet keeps hitting the upload button, I will get as many inserts in to my database as they hit the button.

Is it possible to have the following happen:

1. User hits upload button
2. Excel queries DBase to see if entry already exists by checking date/time stamp that is uploaded initially by Excel.
3. If no database entry has matcyhing date/time stamp then upload is performed.
4. If there is a database entry with a matching date/time stamp then user is asked if they would like to update previous entry
5. The user can then update previously uploaded entry or cancel out

In my experience, however limited it maybe, nothing is impossible when it comes to programing. So I assume this is possible, I just don't currently have the knowledge to make it happen.

Thanks for your time,

JB