SQL Syntax
 

Hi All,

I am connecting excel and access.

In my excel - I have 10 columns

My first column is unique and same available in Access table.

The user want to update may be only 3 column details.

User will input unique id in column 1 and input other details in the
respective column.

Once clicks update I need to update only those three fields and not
all the 10 fields.

I am getting SQL syntax to work around this, any suggestions or
solution ??

SQL Syntax
 

fi.or.jp.de was thinking very hard :
Hi All,

I am connecting excel and access.

In my excel - I have 10 columns

My first column is unique and same available in Access table.

The user want to update may be only 3 column details.

User will input unique id in column 1 and input other details in the
respective column.

Once clicks update I need to update only those three fields and not
all the 10 fields.

I am getting SQL syntax to work around this, any suggestions or
solution ??

Here's a good place to start...

http://www.appspro.com/conference/Da...rogramming.zip

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc