|
OutputText.mdb (intermediate) |
||||
Please consider donating $1 per sample downloaded, find out why here |
Download OutputText.zip Access 97 (23 KB) |
This illustrates a simple way to precisely format data for text output. Assuming the following table: ID Field1 Field2 Field3 Field4 1 111 1/2/1999 4.2587 3.5% 2 222 1/3/1999 3.598745 5 % where Field1 is an integer, Field2 is a Date, Field3 is a Single, and Field4 is a Single formatted as percent, and assuming you want the following output: 1,"000111",#Jan 02, 1999#,4.26,00350 2,"000222",#Jan 03, 1999#,33.60,00500 The code in Module1 will produce the called "Table2.txt" in your "My Documents" folder. |
||||
|
|||||
|
|||||