Hi,

I was connecing to a dbo tabe using sql query code

the dbo name was Ab_cd_ef.dbo and everything run fine.

Now I have another dbo to which i want to connect. the dbo name is
Ab.cd.ef.dbo and it generates an error.(exceeds maximum prefixes
allowed) I cud connect using Access, but if there a way to do this with
excel itself?

thanks