What is the SQL syntax using in Excel?

  • Thread starter Thread starter yaya via DotNetMonster.com
  • Start date Start date
Y

yaya via DotNetMonster.com

Hi, I'm using OldDB to connect excel in my Windows application with some SQL statement like
=====================================================
string strCom = " SELECT * FROM [Sheet1$] ";
=====================================================
If I wana use the UPDATE command to set a particular field in Excel,
like A1, how can I write the SQL statement?

Thankz...
 
Better post to microsoft.public.excel.programming or
microsoft.public.excel.daoquery

Willy.
 
Back
Top