Results 1 to 2 of 2

Thread: Access Help

  1. #1

    Access Help

    I have 150 tables in an Access 2000 database. I need to transfer all tables into a delimited txt file and import it into and Informix database. How should I go about this? Since there are so many tables and I don't want to manually to it 150 times, do I need to write some code in Macros to do this?? Any help would be very appreciated.

  2. #2

    Re: Access Help

    Do this code:

    Public Sub DumpTablesAsText
    #if A2K then
    dim t as dao.tabldef, db as dao.database
    dim t as tabledef, db as database
    const HdrRow as boolean = true
    set db = currentdb
    for each t in db.tabldefs
    if left(,4) <> "Msys" and left(,4) <> "Usys" then
    DoCmd.transferText acExportDelim, ,, "C:" & & ".txt", HdrRow
    end if
    next t
    end sub

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts