Error on FK columns, data type on import from Excel

Toad Data Modeler
1

Hi all,

I have a problem with importing data from Excel (Comments). Whenever I do an export and then an import I get errors on all FK columns as in image below. There were no changes in the Excel. Just Export - Import of the same file.

Is there something that I’m doing wrong? TDM version is 5.5.

Error_on_FK.png

2

I’ve tried the same thing with CSV and I get the same result.

Has anyone had any similar experience with this?

Thanks,

Ivan

3

Hi,

Export and import should work correctly.
Please, can you send us the model and exported excel file to modeling@quest.com?

We will test it and let you know our findings.

Thank you,

Vaclav

4

Hi,

I’ve sent you the model and Excel file.

Thanks,

Ivan

5

Hi Ivan,

There was an error in the import process that was fixed as a part of TDM 6.0 development. Please try it again in Toad Data Modeler 6.0 which was just released a couple of days ago.

Regards,

Lukas

6

Thanks, I will try in in the next few days.

BR,

–

Ivan