RE: Migrating Access Tables -- Empty Columns, Date and Time

2004-06-29 Thread Victor Pendleton
Show warnings is not available until 4.1.x ... The empty field will be imported as that. Empty and not a null value. ... Have you tried importing the data yet to see how the date fields look in MySQL? -Original Message- From: Robert L Cochran To: [EMAIL PROTECTED] Sent: 6/28/04 9:20 PM Sub

RE: Migrating Access Tables -- Empty Columns, Date and Time

2004-06-29 Thread Osvaldo Sommer
Why don't you use the export utility in ms access to load the data into mysql. The export will create the table in the database. All you need is a dsn connection and the mysql odbc. Osvaldo Sommer -Original Message- From: Robert L Cochran [mailto:[EMAIL PROTECTED] Sent: Monday, June 28,

Re: Migrating Access Tables -- Empty Columns, Date and Time

2004-06-29 Thread Wesley Furgiuele
Bob My versions are Access 2000 and MySQL 4.0.20. Here's what I do. When exporting my Access table, I choose the file type Text Files. Then, on the next dialog box, make sure to click the Advanced button to get to the formatting information. Change the date order to YMD and the date delimiter to