MyODBC / Access2000 errors

I have seen other similar posts but I have not seen any final answers. I'm at the pulling my hair out while screaming point. I cannot get Access2000 to export data to MySQL to save my life. It keeps giving me this error: Information type of of range #0.
It also at one point was continually giving me the call failed #0 error I've been seeing posted too. As a note, MySQL is installed on an NT4 Server and I'm working from an NT4 workstation. I have not set up any users - only root with no password is available.

[This message has been edited by hardroc (edited May 23, 2000).]

[This message has been edited by hardroc (edited May 23, 2000).]

I am a newbie and Use Access 97, but when I import to DB I do the following and see if it will work for you.

I make sure columns are named and ordered the same in each database table.

I export from Access as .txt without the column names.

From there I can usually import into the DB table.

------------------
Terry Thon
terry@biz-1.com
(Databases, Cold Fusion Web Applications)