Both (id_Predio and Id_fogo) are primary keys in their tables.

I have tried what you say.

Create a foreign key between table fogos and table avaliacoes and then create a second foreign...

hum...

Or i don't undestand you or you don't understand me 🙂

I will explain again

I have a excel file which , with your help i connected to SQL Server 2005.

I have...

Yes, but there that is not the problem...

The problem is:

I have to create a report through excel to send to the CEO of the company.

He wants the...

It seems to work but when i pass the Excel to other computer it still shows the connection to SQL Server.

I wanto to extract data , but then want to...

hte query?? what is that??

I am not very good working with excel...

No paste especial didn't help...

What is that?

"paste special/Text"

It seems to work, but still have a problem.

The data is not on a single column as it should, so its difficult for me to copy and paste it on...

Thank you dave

I question too...

It was not my decision. It was a decision from other person...

I think that varchar is good, no need to have unicode columns in my case (nvarchar)

I found how to do it.

Thank you very much

Yap,

The problem is how to put that on this:

"SELECT TOP (100) PERCENT '1'+replace(rf.repf_id,'.','') as repf_id"

This is my ID column

hum.... that's right. One of the tables was a view...

Thank you very much

i have deleted all the tables that where called by this view, still same error...

Didn't undestood your question...