[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: Sigurd Andersen <sigurd@solbakkn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___