Changing "Import Specification" order

[Air_Cooled_Nut]

I have an import specification and it works fine. It is used for a .csv file. My end user has changed their output of the .csv file. The fields are the same, however, the order has changed. Naturally, this causes a stink with the designated Import Specification.

Is there an easy way to change the Import Spec without having to import the changed file? I have the list of fields and their new order (eew, bad phrasing there ) but don't have the changed output file yet.

It'd be nice if MS had a more robust import spec. flexibility...

BTW, I'm an absolute Access VBA programmer and I'd rather avoid it if possible. I understand Excel VBA, though.

<edit>Being able to insert a row would be most helpful.</edit>

 

[fuzzygeek]

To the best of my knowledge, there is no easy way to alter an import specification. There used to be an easy method using the schema.ini file, but I have seen no reference to it since ACCESS 2000. It was designed in notepad and was easy to change. See the following for additional info:

http://support.microsoft.com/default.aspx?scid=kb;en-us;241477