same problem.

I can send you the file, if you want . It only as 186 rows

Same problem...

Most of the data is inserted as null....

Sample of data of one of the columns:

866030 - data imported

866020- data imported

866030- data imported

866010- data imported

866030- data imported

863040-- data imported

852206-- data imported

852206 - data imported

06206 - data not...

186 rows inside the file on sheet1

XLS

all columns are varchar.... with a great size...

i see the column but no data.

I can only see some of the data,...

thank you very much.

Problem solved.

data:

0

200

100

0

20

700

....

data type = float

" would never automaically change the compatability level ot 90 after an upgrade "

I would never too...

The database will be tested with the app

"I agree about the checksum change. That would be higher on the priority list to be changed"

but you can only change the to checksum if you are in compatibility level...

What i need is a trigger or a check constranit to get referencial integrity.

Can someone help me on making a trigger to do this?

"If I understand you correctly then you cannot have a single ID in your third table as a FK to two other tables (predios & fogos) unless the ID exists...

I don't think so.

I think that what happens it's this:

I create a new FK referencing the table predios (Id_predio)

I then create another FK referencing table fogos (id_fogo)

When i try to...