@x8g2000yqk.googlegroups.com>, jo***********@illinois.gov says...
Is there no way to do this?What book are you learning from? SQL that might work for SQL Server
2008 will not work in Access.
Why not just download the free SQL Server Express 2008 onto you PC and
try running your insert there? Then you can use Access for forms and
reports and also use all the latest SQL features of SQL Server.