Subject: Migrating Access Tables -- Empty Columns, Date and Time
I'm migrating a Microsoft Access 2002 (Service Pack 3) table constructed
by my wife to a corresponding table in MySQL 4.0.20. Some columns in
most of the 3000+ rows are empty. Some of these are contiguous empty
columns. I don'
ne 28, 2004 8:21 PM
To: [EMAIL PROTECTED]
Subject: Migrating Access Tables -- Empty Columns, Date and Time
I'm migrating a Microsoft Access 2002 (Service Pack 3) table constructed
by my wife to a corresponding table in MySQL 4.0.20. Some columns in
most of the 3000+ rows are empty. Some of
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
I'm migrating a Microsoft Access 2002 (Service Pack 3) table constructed
by my wife to a corresponding table in MySQL 4.0.20. Some columns in
most of the 3000+ rows are empty. Some of these are contiguous empty
columns. I don't know if Access considers them NULL or not, but when you
export an Acces