Mark changes in Excel

I have a database in access. I bring information with DAO to Excel so that user can change / update information and then upload it to Access again.

I want to mark in Excel (maybe put a "1" in a cell) all records that suffer changes.

any idea?

thanks

bregards

[275 byte] By [Santig] at [2008-2-3]

«« Hierarchical data inserts with autoincrement fields
»» Disapearing Records

# 1

What you can do is import the data into a dataset in the cached data. Then databind the cells to the cached data. You can then monitor the changes to the dataset and not the cells.
Paul Stubbs
Program Manager - VSTO
http://blogs.msdn.com/pstubbs/

PaulStubbs at 2007-9-8 >

Visual Studio Tools for Office

Visual Studio Tools for Office Hot Topic

Visual Studio Tools for Office New Topic

Visual Studio Tools for Office

Visual Studio Tools for Office

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech