>Wayne
>
>Thanks for the code - but it doesn't seem to work.
>
>I get
>
>SQLEXEC(ln,lcsql) - invalid connection handle


I created an odbc dsn to a local access database - you would have to do the same thing. The sqlconnect on the first line makes a connection to 'dbtest'. It won't work as-is on your computer without that connection.

Also, this is by no means an all inclusive set of code. It will not work with fields that are not character type. You will need to expand on it to make it completely work. It is just a start...