Re: Import wizard error - item cannot be found
I've been importing data into Recorder 6 without too many problems, but today have encountered and error message that I've not been able to track down. I'm trying to import an Excel file of around 5000 records, which are in the same format that has successfully imported before. The message says:
date/time : 2009-04-08, 12:44:26, 914ms
computer name : BRC250507
user name : PurgleL
operating system : Windows XP Service Pack 3 build 2600
system language : English
system up time : 1 hour 27 minutes
program up time : 26 minutes 58 seconds
processors : 2x Intel(R) Pentium(R) D CPU 3.00GHz
physical memory : 409/999 MB (free/total)
free disk space : (C:) 51.24 GB
display mode : 1280x1024, 32 bit
process id : $1a4
allocated memory : 22.83 MB
command line : RecorderApp.exe /590784
executable : RecorderApp.exe
exec. date/time : 2008-11-04 09:45
version : 6.13.3.182
madExcept version : 2.7h
exception class : EOleException
exception message : Item cannot be found in the collection corresponding to the requested name or ordinal.
main thread ($af4):
0062949b RecorderApp.exe DatabaseAccessADO 425 TdmDatabase.CheckError
0062bac2 RecorderApp.exe DatabaseAccessADO 912 TdmDatabase.ExecuteSQL
008e8ac7 RecorderApp.exe IWColumnMappingClasses 2244 TImportFile.PopulateMasterTable
008e84a3 RecorderApp.exe IWColumnMappingClasses 2086 TImportFile.LoadData
008e9402 RecorderApp.exe IWColumnMappingClasses 2379 TImportFile.PrepareData
0090a704 RecorderApp.exe ColumnTypes 688 TfraColumnTypes.PrepareTempTables
0090b631 RecorderApp.exe ColumnTypes 997 TfraColumnTypes.ValidateContent
008fd223 RecorderApp.exe ImportWizard 186 TfrmImportWizard.btnNextClick
004b4048 RecorderApp.exe Controls TControl.Click
004a9160 RecorderApp.exe StdCtrls TButton.Click
0046ff09 RecorderApp.exe Buttons TBitBtn.Click
004a9254 RecorderApp.exe StdCtrls TButton.CNCommand
004b3eb0 RecorderApp.exe Controls TControl.WndProc
004b6f0f RecorderApp.exe Controls TWinControl.WndProc
004a9024 RecorderApp.exe StdCtrls TButtonControl.WndProc
006f42d4 RecorderApp.exe XPMenu 2928 TControlSubClass.ControlSubClass
7c90eb74 ntdll.dll RtlAnsiStringToUnicodeString
004b3c80 RecorderApp.exe Controls TControl.Perform
004b7047 RecorderApp.exe Controls DoControlMsg
004b769f RecorderApp.exe Controls TWinControl.WMCommand
004b3eb0 RecorderApp.exe Controls TControl.WndProc
004b6f0f RecorderApp.exe Controls TWinControl.WndProc
004a9024 RecorderApp.exe StdCtrls TButtonControl.WndProc
00445985 RecorderApp.exe Classes TList.Delete
004b6b8c RecorderApp.exe Controls TWinControl.MainWndProc
004528d8 RecorderApp.exe Classes StdWndProc
7e4292de user32.dll SendMessageW
7e42a993 user32.dll CallWindowProcA
004b6ff3 RecorderApp.exe Controls TWinControl.DefaultHandler
004b4450 RecorderApp.exe Controls TControl.WMLButtonUp
004b3eb0 RecorderApp.exe Controls TControl.WndProc
004b6e41 RecorderApp.exe Controls TWinControl.WndProc
004a9024 RecorderApp.exe StdCtrls TButtonControl.WndProc
006f42d4 RecorderApp.exe XPMenu 2928 TControlSubClass.ControlSubClass
004b3c80 RecorderApp.exe Controls TControl.Perform
004b6b8c RecorderApp.exe Controls TWinControl.MainWndProc
004528d8 RecorderApp.exe Classes StdWndProc
7e4196c2 user32.dll DispatchMessageA
004d4de3 RecorderApp.exe Forms TApplication.ProcessMessage
004d4e1a RecorderApp.exe Forms TApplication.HandleMessage
004d503a RecorderApp.exe Forms TApplication.Run
0099f832 RecorderApp.exe RecorderApp 317 initialization
Any ideas what's wrong?
Thanks
Purgle
Purgle Linham
Head of WSBRC
Wiltshire & Swindon Biological Records Centre