i'm trying to import records from a different table in the same remotely hosted file.
The weird thing is that sometimes it works and sometimes it doesn't. Its not executed from a script or anything, just plain old file>import file.
I paste the filepath and run teh import. It either imports everything or imports 0 records.
I would love to know why if someone else ran into this same thing.
A quick check - if the file that you are importing from is open, then the import will only bring in the current found set. So you may need to add a step to your procedure to show all records in the table you want to import from - or at least to find the appropriate records.
A good argument for scripting - you don't have to remember those steps.