Re: Get External Data in Access 2003

Tech-Archive recommends: Fix windows errors by optimizing your registry

ACCESS creates a table containing the ImportErrors that you are finding.
When you get the error message, it'll tell you there (or in a subsequent
window) the name of the table. It should be visible in the database window.
--

Ken Snell
<MS ACCESS MVP>



"pgeo" <pgeo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BB714BC1-8FE9-4C68-891E-5ECC7F7F15E2@xxxxxxxxxxxxxxxx
> Firstly, sorry if this has been covered a hundred times before.
>
> I'm creating a table in Access, defined fields and validation rules. I
> import a text file into the table. One record is rejected due to
> validation
> checking as intended (this is an educational exercise). BUT, Access does
> not identify it. The only way I can find it is by doing a visual check,
> which kind of defeats the wonder of computers.
>
> Does anybody know how I can get Accessm2003 to record what data it
> rejects?
>
> Thanks,
>
> pg


.

Quantcast