Hi there,

I have a 45000 record transaction table that I need to move to mysql from ms
access everyday, and it used to work to:
1. empty out the link table (mysql db)
2. copy the ms access table contents to the mysql link table.

These queries I attached to a button as part of a daily process run by a
user.

The process started hanging at about 35000 records copied and gives an
overflow error.

That's probably not enough info, but if you tell me what else to provide
that might help I sure would appreciate the help.

If there is some better way to do this I'm certainly open to that as well.

Thank you.

David Fair
Technology Coordinator
IDEA International
907-562-4332



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org

David Fair wrote:

>
>Hi there,
>
>I have a 45000 record transaction table that I need to move to mysql from ms
>access everyday,
>
Why don't you skip the Access storage complete, and insert stuff
directly into MySQL from the start?

> and it used to work to:
>1. empty out the link table (mysql db)
>2. copy the ms access table contents to the mysql link table.
>
>These queries I attached to a button as part of a daily process run by a
>user.
>
>The process started hanging at about 35000 records copied and gives an
>overflow error.
>
>
>
Maybe one of your fields in your MySQL table isn't big enough to accept
data from your Access tables.

>That's probably not enough info, but if you tell me what else to provide
>that might help I sure would appreciate the help.
>
>
Your table definitions, from Access and MySQL.
You'll have to type out your Access definition by hand. Your MySQL
definition you can get from the 'mysql' client by typing:

show create table my_table_name;

>If there is some better way to do this I'm certainly open to that as well.
>
>
See above point re: not using Access to hold data. I've had bad, bad
experiences with Access holding anything more than 10,000 records,
especially in a multi-user situation. Access is fair enough for a
front-end, but with linked tables to a real database server.

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak [at] nusconsulting.com.au
website: http://www.nusconsulting.com.au

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org