| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Jeffrey Mercer | Date: | April 9 1999 9:43pm |
| Subject: | exporting big access file to mySQL corrupts access DB | ||
| View as plain text | |||
I have fairly big table to be exported ( via access97 ) to a mysql DB running on a remote server. Each attempt results in err: (TCX)(MyODBC)Unknown column '110yyyyy' in 'field list'(#1054) I know that this occurs some 500 records into the save. Also, after failure, all links from access to mysql are busted and cannot be restored by rebooting or using the Link Table Manager. The only thing that seems to work is to delete the bad links and redo them. Help! -- Best Regards, Jeff @ Industrial House http://www.industrialhouse.com jmercer@stripped
| Thread | ||
|---|---|---|
| • exporting big access file to mySQL corrupts access DB | Jeffrey Mercer | 10 Apr |
| • Re: exporting big access file to mySQL corrupts access DB | webmaster | 10 Apr |
| • How to export Access file to MySQL [Was Re: exporting big access file to mySQL] | Naresh Bhagtani | 12 Apr |
| • How to export Access file to MySQL [Was Re: exporting big access file to mySQL] | Jani Tolonen | 14 Apr |
