I need to schedule DTS package which convert the excel sheet into SQl 2000 table. Excel sheet has some macros also. When i am trying to import data i am getting a error msg
Microsoft Jet Database Engine External table is not in the expected format
error during intialization of the provider.
i have arround 12 same Files(Monthly File) and every file has 65000 lines some are ok some has this error.When i copy these file to new excel sheet it's working
Not able to understand.............