dcsimg


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: Convert .mdb to text file

  1. #1
    Join Date
    Aug 2004
    Posts
    43,023

    Convert .mdb to text file

    [Originally posted by Tim Stutzman]

    Is it possible to convert a MS Access database to a text file?

    Thanks
    Tim

  2. #2
    Join Date
    Aug 2004
    Posts
    43,023

    Re:Convert .mdb to text file

    [Originally posted by Mike Lyons]

    >>Is it possible to convert a MS Access database to a text file?
    <<

    In what context? Do you want to export the data to a text file? Are you trying to get a text description of the design of the table structures?

    Are you wanting to export the definitions of objects, such as modules, forms, reports, etc. as text?

    Mike

  3. #3
    Join Date
    Aug 2004
    Posts
    43,023

    Re:Re:Convert .mdb to text file

    [Originally posted by Tim Stutzman]

    I would like to export the data in the table only with separated columns in the text file.

  4. #4
    Join Date
    Aug 2004
    Posts
    43,023

    Re:Convert .mdb to text file

    [Originally posted by Jim]

    Yes. How you do it depends on where you plan on doing it. If you want to build an application, you can use VB, if you want a routine within the database, you can use vba or if you want to do this manually, you can use the file/save as menu item.

  5. #5
    Join Date
    Aug 2004
    Posts
    43,023

    Re:Re:Re:Convert .mdb to text file

    [Originally posted by Mike Lyons]

    Are you doing this fro VB or from within Access?

    In Access, you can use DoCmd.TransferText

    In VB, you will want to create a recordset and loop through it, and print the values to a text file opened using the Open statement.

    Mike

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center