Creating .asc text file from Access - need urgent help ! (1 Viewer)

[edtab]

I have a project that requires creating a text file (.asc extension) using an Access table as its source. I have done this before using a "transfertext" program in VBA; however, this last one has slight twist to it.

The resulting .asc file file has to be broken down into two rows for each record being exported out of Access. In other words, you wold end up with a two line entry in the .asc file for each record in the Access table being exported out.

I would appreciate to hear from any one who has done this before or can point me to the right resource(s). As I am under time contraint (due in one week), a speedy reply would be very much appreciated.

Thanks,

Edtab

 

[AppStaff]

Create a make table query that formats the data per the output requirements and then just export to text.