It's when I'm importing it to a temporary table that I get the errors. I'm trying to import without getting a new "import errors" table every time.
I tried changing the fields in the temporary table to text fields and changing the import spec. the same way, but Access seemed to change the
temporary table fields back to date fields. I could have missed some step in this and given up too soon before getting a successful test.
Sigurd
What about dropping it into a Temp table then clean the data and append to the live table? You can set up an Import and clean on a command button with some update queries.
Gina Whipp
Microsoft MVP (Access)
<http://www.access-diva.com/> access-diva
Specializing in Microsoft© Access® Solutions
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Saturday, December 19, 2015 2:13 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Import errors
No, the text is sometimes zero length strings. The text file being imported is using tildes as delimiters, and the fields in question have problems when there are two tildes in a row at the spot for the field in the input. So "~~" instead of "~12/25/16~".
Sigurd
On 12/17/2015 5:30 PM, 'Bill Mosca' wrmosca@comcast.net [MS_Access_Professionals] wrote:
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/> http://thatlldoit.com
MS Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My Nothing-to-do-with Access blog
http://wrmosca.wordpress.com
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
[Non-text portions of this message have been removed]
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 (5) |
Tidak ada komentar:
Posting Komentar