Can anyone tell me why you have to create 2 sets of import specs for the same one? When I save and name an import it shows up in the Save Imports screen, but, when I want to use that same spec in VBA code, it tells me it can't find it and I have to use the "Advanced" button in the import process to create one in that other window.
I just split my database (Access 2007) and selected to bring over my import specs, but it only brought over the first set which my code won't recognize. I have attached screenshots which will hopefully explain what I am running into.