MS Edit and Sql "Dkso" <dkso[ at ]ntlworld.com> 30.11.2005 17:19:56 Does anyone know and can you tell me where I can get a list of the SQL commands that work in MS Edit supplied with MSExcel 2000. Thanks Dean -- dkso[ at ]ntlworld.com http://www.dkso.co.uk/ http://homepage.ntlworld.com/dkso

Re: MS Edit and Sql Bill Manville <Bill-Manville[ at ]msn.com> 01.12.2005 12:02:00 I haven't heard of MS Edit. Do you mean MS Query? Bill Manville MVP - Microsoft Excel, Oxford, England

Re: MS Edit and Sql "Dkso" <dkso[ at ]ntlworld.com> 01.12.2005 18:30:12 Sorry....Yes MS Query "Bill Manville" <Bill-Manville[ at ]msn.com> wrote in message news:VA.000013bb.024b620c[ at ]msn.com... [Quoted Text] >I haven't heard of MS Edit. > Do you mean MS Query? > > > Bill Manville > MVP - Microsoft Excel, Oxford, England >

Re: MS Edit and Sql Bill Manville <Bill-Manville[ at ]msn.com> 03.12.2005 08:10:56 As I understand it, MS Query uses ANSI SQL-92 syntax. It works via database-speecific ODBC drivers (which may restrict the set of operations available with that particular type of database). Via the MS Query SQL window you can execute any type of query that the ODBC driver supports. The following books might be helpful: A Visual Introduction to SQL, 2nd Edition David Chappell; J. Harvey Trimble A Guide to SQL Standard Date, C. J. Darwen, Hugh Bill Manville MVP - Microsoft Excel, Oxford, England