Hi macrocharlie,

once you get to that point you can save what options you want as a spec and call it a name which you can use in your vba...

Hi again,

Ok - another try   I don't have 2003 to hand I'm afraid but looking at 2002.

Have you tried exporting the file manually...

Hi macrocharlie,

I just did a quick test on one of my databases and found the same. It appears as though Access defaults the delimiter to a comma when using acExportDelim,...