Thread: SQL Syntax
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
fi.or.jp.de fi.or.jp.de is offline
external usenet poster
 
Posts: 93
Default 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 ??