Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export Data from Access to Fixed-Width .txt file

Status
Not open for further replies.

mrussell71

IS-IT--Management
Nov 28, 2001
20
0
0
US
I have been unable to find any articles on how to create a fixed width text file from an MS Access DB using VB.Net. I have an application which runs stored procedures to delete records based upon pre-determined criteria, it then compacts the DB, and finally I need it to create fixed-width text files of the 3 Access tables and place them in a shared folder so they can be uploaded to an AS/400 system.


Has anyone come across any articles or know of any code snippets that would explain this process in some detail?

Is there a command that uses the current connection to the Db and creates text files?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top