You can easily get the query syntax in Excel. Do the following
1) From : worksheet menu
Data - Import External Data - New Database Query
2) Select Ms Access Database browse for access file
3) Select the table and columns (if you don't see the table then go
into options and select all the boxes)
3) Press Next and sleect any filtering you want
4) Press Next to get to last box with finish button
5) Press button that say to View Data or edit query in Microsoft Query
6) Press Finish and the Query editor wil come up. there is a SQL
button that will have the the proper syntax of you SQL. You can also
make changes to the SQL and you will get errror messages letting you
know if you made any errors. Sample of you data will also appear in the
window so you know if you got the correct data.
--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=167796
Microsoft Office Help