RE: Saving Action Query Warnings

Tech-Archive recommends: Speed Up your PC by fixing your registry

If you need to do this, you will be reduced to a one at a time situation.
Bulk imports and exports are just one command and there is no facility to
exclude records that can't be imported.

There is one other option, but whether it would work for you would depend on
the nature of the data you are importing. What format is the data coming in
in? Excel, text file, external database, etc?
--
Dave Hargis, Microsoft Access MVP


"StatBoy" wrote:

I'm working on automation for a bulk data import function that will be used
repeatedly. I'd like to find a way to SAVE the warnings that Access often
displays during execution of an "append" query. These would be useful
history for the user to review and it would be very convenient to simply
stash them in rows of a table characterizing the overall data import
operation.

Say for instance I'm trying to append 2000 records. And Access in response
displays a message indicating 12 key violations, and 20 validation rule
violations. I'd like to be able to store that message for more detailed
examination by the user at a later time.

Can't seem to find a direct, straightforward way to do this. I've
investigated VBA approaches using "Connection.Execute strSQL..." and
"CurrentDB.Execute strSQL...", with subsequent VBA examination of the
"Errors" collection. However, at present it seems that these approaches just
stop the import operation ENTIRELY as soon as any SINGLE error arises. That
doesn't really match my needs here. If 1950 out of 2000 records CAN be
loaded, I want that to be done... so long as I have a record of what I need
to check about the records that did NOT load.

I'm hoping there is a way to do this short of constructing a VBA function
that submits individual SQL "insert" commands for each individual incoming
record...

It also seems to me that SOMEONE out there must have done something like
this already...

Can anyone offer sage experience and suggestions?

Thanks much.


.

Relevant Pages

  • Re: newbie; Update not working
    ... If you were missing Imports statements, your code wouldn't compile at all. ... I think your problem has to do with your command object and its parameters. ... StudentID = @StudentID" ... Also why is there not just a Execute for a sql ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cross Module Command Useage
    ... command that needs to access a command that is in moduleB. ... python program for the commands. ... all the work is done -- later imports do ... in an impossible situation. ...
    (comp.lang.python)
  • BAT file to re-start in Safe Mode...?
    ... and then imports them to my ... indicating a problem with the command line text that does ... the BAT file in Safe Mode with Networking, ... then re-boot into full XP?" ...
    (microsoft.public.windowsxp.general)
  • Re: dumpbin /disasm output
    ... look at using the dumpbin tool. ... The /IMPORTS line shows that it imports 2 dlls and what functions it ... How do I relate the assembly output of the /DISASM command to the ... In the ARM9 instruction set, "bl" is the subroutine call instruction. ...
    (microsoft.public.vc.language)
  • Re: Strange problem: Computers date changes when importing data
    ... For more see the XL VBA help for the 'date statement'. ... Excel, PowerPoint, and VBA add-ins, tutorials ... > I wrote a small VBA routine that imports the data from an Excel spreadsheet ...
    (microsoft.public.excel.programming)