Background:
I'm exporting a table to a CSV file, then uploading to my Web site, run though a PHP converter to change it to an SQL file, then load it into the MySql database.
The date is the problem. If I tell Access the date format is YYYYMMDD, it displays the table correctly, but Access won't export the table! It says "Wizard not found or there is an error in the registry"
Sheesh! A normal date seems to work, up to the point of loading it into the MySQL database, then it gives me all 0s as the date. Any idea how to get around this Access bug?
I'm exporting a table to a CSV file, then uploading to my Web site, run though a PHP converter to change it to an SQL file, then load it into the MySql database.
The date is the problem. If I tell Access the date format is YYYYMMDD, it displays the table correctly, but Access won't export the table! It says "Wizard not found or there is an error in the registry"
Sheesh! A normal date seems to work, up to the point of loading it into the MySQL database, then it gives me all 0s as the date. Any idea how to get around this Access bug?