I tried doing that, But the query generator in excel is giving me an error
when I try generating query with access 2007 that is accdb format. and I
cannot do this by converting it to access 2002-2003 which is mdb format
because that version of access didnt allow attachments.


"joel" wrote:


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

.