Export Table to Text via VBA
Posted on 2003-02-27
The goal of my project is to read in a dbf file, and after some processing, output it as a text file with either comma-delimiting, tab-delimiting, or fixed-width. Given the dbf files can have various field widths and number of fields. What is the best way using VBA to programmatically export the table? I have looked at the TransferText method, but it requires a schema file and I cannot find (through Help or Google) any details on how to build such a file.
Thank you for your help and be kind as this is my first question.