Start with a small SQL and then make it larger.You only need a Select
and From.

.CommandText = Array("SELECT *" & vbCrLf & FromSQL)

Get above working first working first. Then add to the SQL little by
litle until ou get the full SQL string.


The SELECT : Are the columns that get returned
The From: The table in the database
The Whe The filtering which returns theonly rows specified
The Groupby : the Sort order of the returned tables.


I assume you are still getting the Error 13. The query doesn't get
process until the Refresh line (last line of the query). If you get an
error in the Refresh line it indicats soemthing is wrong with teh SQL
statements.

The Error message are very vague. Sometimes it is better to use the ADO
method to connect to a database where the error messages have more
detail.

I tired your code yesterday morning and got past the error 13 by
removing the comma. I only used a SELECT and From portion of the SQL.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=198559

http://www.thecodecage.com/forumz