I've been using isladogs IMEX form found here to import my data into my database quickly.
All was working till I created another import spec and tried running it or changing the file path using the form. Now I'm getting this popup
Error 31602 in line 40 of cmdExecute procedure. The specification with the specified index does not exist. Specify a different index 'import-Components <lot of spaces> '.
For some reason there seems to be a lot of spaces in the name of the shown in the error popup, but there are no spaces when viewed in the "External Data" - "Saved Imports" - "Manage Data Task" form.
It's still working fine for a different data table I'm using, so not sure what the problem could be.
Any ideas?
Thanks
View & Edit IMEX Data Task Specifications
Prior to Access 2007, import/import specifications were saved in 2 system tables : MSysIMEXSpecs / MSysIMEXColumns In Access 2007, this system was largely replaced (but see note below) with a wizard driven & arguably more powerful XML based system of Import/Export Data Tasks. However, ease of...
www.access-programmers.co.uk
All was working till I created another import spec and tried running it or changing the file path using the form. Now I'm getting this popup
Error 31602 in line 40 of cmdExecute procedure. The specification with the specified index does not exist. Specify a different index 'import-Components <lot of spaces> '.
For some reason there seems to be a lot of spaces in the name of the shown in the error popup, but there are no spaces when viewed in the "External Data" - "Saved Imports" - "Manage Data Task" form.
It's still working fine for a different data table I'm using, so not sure what the problem could be.
Any ideas?
Thanks