Access DB using Visusal Basic to Export a fixed data file

[jaggar]

Can anyone help me. I have not used Access since 2003. I need to modify an export file. I cannot remember the steps to do this. I used Visual Basic to perform the process.

DoCmd.TransferText acExportFixed, "ExprtSpec1", strQname,strFileNames.

For ExprtSpec1 I believed I had to click on an icon on the tool bar for which I defined the fields in ExprtSpec1.
I cannot remember the steps to this. My export queries are ok however when I look at my output I have the same field layout and length as it was in 2003.

Can someone give me the beginning and ending steps to perform this process?

Thanks,
Jaggar

 

[HarleyQuinn]

Is this any help?

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[jaggar]

Thanks HarleyQuinn for the information.

Jaggar