• Hi

    this is what im trying to do;

    I have a sql server as follow

    Windows server 2003

    SQL server instance 2000

    32 bit i presume

    i open import and export data --> on destination i choose excel 97-2000 and i locate the excel file, just when i hit next this error comes up

    Error Source: Microsoft JET Database engine

    Error Description: External table is not in the expected format.

    I'm knocked out.