Hi Yogesh, My guess is that the SQL generated by MS Query for your specific data connection is wrong. Normally in SQL the '*' is used as an 'ALL' so that you would have SQL like the following: SELECT * FROM <Insert Table Name Here>
Thats the basic select statement. If the syntax is wrong somewhere the SQL cannot be processed by MS Query, and you will see an error similar to what you have described. Are you able to post the SQL that MS Query is generating in its attempt to get external data? I can probably correct it if it is not too complex. Cheers The Frog -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel