Create a billing file.

[doran_doran]

Please download the database from the link below.
http://www.dbforums.com/attachment.php?postid=3602706

1. Please look at my excel file.
2. Our billing department wants a billing file according to attached excel file.
3. every record has three lines.
4. each line contain specific info
5. space delimited format.
6. there are some static data
7. and most of the dynamic data and bunch of empty spaces bet data.

How do I accomplish this?

Help will be appreciated.

Dianna

 

[Travis]

You can use Excel Automation to do this:

MS Knowledge Base