DoCmd.TransferText Using Export Delimiter differently than ManExport?

[kjv1611]

I've got a weird one - well, weird to me anyway.

In a database where a couple steps in a process include manually exporting tables to text files, I thought I'd automate that piece with DoCmd.TransferText.

Well, it works, but it spits the data out differently. Here's the differences I can see right away:
[tt]Manual: DoCmd.TransferText:
Tab Delim Comma Delim
Few Fields More Fields[/tt]

First, I thought I must have typed the delimiter wrong, and it must be that I'm using one that I didn't mean to. But I've double and triple verified that I'm using the same delimiter.

Is it possible that using the same export delimiter for multiple tables with different field counts could throw off the export delimiter in VBA, but not in the manual export??

Thanks for any suggestions..

 

[kjv1611]

I found it! I found the issue, ... I think...

Going to test, but duh... wasn't thinking... it's fixed width... so should be

DoCmd.TransferText acExportFixed

instead of

DoCmd.TrasnferText acExportDelim

So I'll test to be sure and post back.