Senin, 21 Desember 2015

Re: [MS_AccessPros] Import errors

 

I'm using an import specification, using it via VBA.
Previously I was using the following code, which was working, but didn't seem to work when I changed the import specification.
     SendKeys ("{ENTER}")
    CurrentProject.ImportExportSpecifications("Get_SOTRAN").Execute (False)
    MsgBox ("Sales Orders Re-Imported")
When I had problems with this in my recent work (data being importing has changed),
I found a new way of running the import specification which works just fine.
    DoCmd.RunSavedImportExport ("Get-SOTRANS")
This replaced the first two lines (the "SendKeys" sent an "Enter" to the earlier import procedure.
If I left it in the new code it would close the MsgBox before the user ever saw it.

Maybe I ran into a problem of "sometimes changes don't stick" - I'll give your remove & redo a try.
Thanks, Gina
Sigurd

On 12/19/2015 12:55 PM, gina@access-diva.com [MS_Access_Professionals] wrote:
 

Are you using an Import Specification or VBA? If a Specification you may have to remove and completely redo as sometimes changes don't stick. If VBA, please post.

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 8:10 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Import errors

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

On 12/19/2015 2:19 AM, gina@access-diva.com [MS_Access_Professionals] wrote:

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/> <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/> 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]

[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 (7)

.

__,_._,___

Tidak ada komentar:

Posting Komentar