Microsoft Jet Database Engine (dts Error)

[japuentem]

Hi all

I am trying to create an axcel connection using the DTS excel connection but when I try to assign the excel document to the Excel Connection object, it return the following error:

Error source: Microsoft Jet Database Engine
Error description: External Table is not in expected format

What format should i use in my excel document?

Regards