I've tried to fix it with use of the import export wizard, but I still didn't succeed. When running the package made by the wizard, the first task is succesfull => create a dbf file. (I've choosen the option 'Free table directory') But the next task, the data flow task fails with the messages:
[Destination - Query ] Error: The "input "Destination Input" (32)" failed because error code 0xC020907B occurred, and the error row disposition on "input "Destination Input" (32)" specifies failure on error. An error occurred on the specified object of the specified component.
[DTS.Pipeline] Error: The ProcessInput method on component "Destination - Query" (19) failed with error code 0xC0209029. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.
[DTS.Pipeline] Error: Thread "WorkThread0" has exited with error code 0xC0209029.
(AlwaysUseCodePage is set to True)
Please help me!!