Hi again,

Even when copy and paste I some time have problems
a simple space missing or quote not position correctly and there you go.
Try this,
Run you query bit by biit and see at which stage you have a problem
Select A FROM ..
Select A, B FROM
Select A FROM WHERE ...

By the way, are you really using ADO, or DAO
In the excell DB query, the SQL string length is limited to a certain
maximum of characters.
The solution is then to convert the SQL string in an array.

Regards

JY


"gti_jobert" wrote
in message ...

Also....when I open up my Db table the [Date] Col is displayed in format
'24/03/2006'

Dont have a clue what I'm doing wrong


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile:
http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=529937