Re: Get External Data in Access 2003

Mmm. So - if I'm reading the message from Access correctly, it is saying
that not all data has been passed to the table (my one missing record), but
it is not offering to tell me what is being excluded. Any thoughts as to
where I can take it from here? Or have I remarkably found a new bug that
no-one knows about (which I think is unlikely)?

pg

"Ken Snell [MVP]" wrote:

> I've not seen or experienced your result; I would not expect what you're
> seeing, especially being told that zero records are being lost, and then
> losing one or more records.
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
>
> "pgeo" <pgeo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:B4D9314D-D258-4966-A34C-C250C7E028E4@xxxxxxxxxxxxxxxx
> > Sounds great, but that's not happening.
> >
> > What I do get is:
> >
> > "Microsoft Office Acces was unable to append all the data to the table.
> >
> > The contents of fields in 0 record(s) were deleted, and 0 record(s) were
> > lost due to key viiolations.
> > *If data was deleted, the data you pasted or imported doesn't match the
> > field data types or the FieldSize property in the destination table.
> > *If records were lost, either the records you pasted contain primary key
> > values that already exist in the destination table, or they violate
> > referential integrity rules for a relationship defined between tables.
> > Do you want to proceed anyway?"
> >
> > At this point I click yes and get the table created minus one record.
> >
> > "Ken Snell [MVP]" wrote:
> >
> >> 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
> >>
> >>
> >>
>
>
>
.

Relevant Pages

  • Re: is EVENT_BUFFER_SIZEs default too small? [LONG]
    ... > more events than Tk can handle, the oldest events are lost. ... > press and also a window raise event. ... > set mainframe ... > pack $b -side top ...
    (comp.lang.tcl)
  • Re: Getting my device back.
    ... These are lost when the device is lost. ... L. Spiro wrote: ... > full-screen window, and all is normal in that respect, until you bring the ... Dragging the edge of the window causes ...
    (microsoft.public.win32.programmer.directx.graphics)
  • Re: DWOs missing episode hunt.
    ... Zarbifarce gets lost because he took the wrong plane to the ... wrong destination, but he finally gets to New Zealand. ... then navigate an airport and find the proper plane. ...
    (rec.arts.drwho)
  • Re: [SLE] cannot find a program
    ... > the small window with the kinternet susewatch icons. ... > zip drive and to see the size of the mounted drives and ... Can somebody tell me what I lost and how to get ...
    (SuSE)
  • Re: How do you access second display adapter without being a desktop extension?
    ... That only happens when you put one of the devices in exclusive mode -- ... the other device is then lost. ... You can do this as long as both have their own HWND*. ... lost when you try, as when you attach a device to a window, ...
    (microsoft.public.win32.programmer.directx.graphics)