Sigurd – What does the blank field look like? Open the text file in something like Notepad++ and switch on the option to show non-printing characters. Maybe the field is not really empty as in zero-length string.
Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT http://thatlldoit.com
MS Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My Nothing-to-do-with Access blog
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, December 14, 2015 5:57 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Import errors
Is there a way to eliminate some of the errors that Access flags on
importing information from a text file?
In my case, there are some date fields which are blank in some records.
The import generates a new table, TextFileName-ImportErrors
For each row in which one of these date fields is blank this new table
gets a "Type Conversion Failure".
Should I import these fields as text and then convert to date fields in
another step after importing?
Thanks for any suggestions/help.
Sigurd Andersen
Posted by: "Bill Mosca" <wrmosca@comcast.net>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar