Kev, Please, download, http://www.hostcl.com/zip/exportar.zip This bas module was adapted to export all tables from databases to xxx.txt. Using xxx.sql itīs fine. Hope you can read some spanish! Change database name and name for text files as your requires. Call exportSQL funtion w/o parameters from any form in your vb app. The best way to give the txt file to mysql have been with phpMyAdmin. The file delete tables in your mysql database, re-create empty tables and transfer data for that table, one pass for table. Best from Santiago de Chile Charliej

Originally posted as a Categorized Answer.

In reply to Re: Transferring an Access Database to mySQL by Anonymous Monk
in thread Transferring an Access Database to mySQL by kevin_i_orourke

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.