John
Wait until you've been doing this stuff for as long as some of us. It starts to become second nature. Although there is nothing natural about Access. Normal, yes. Natural no.
Bill
--- In MS_Access_Professionals@yahoogroups.com, "yshopper" <mossj5@...> wrote:
>
> Thanks Bill. I should have checked that before.
>
> --- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@> wrote:
> >
> > John -
> >
> > Open both tables in design view and make sure the BibID in each table has the same data type. Lots of times An excel import will end up having the wrong data types.
> >
> > It will probably be a simple matter of just changing the Excel data table field to match the existing table.
> >
> > Regards,
> > Bill Mosca, Founder - MS_Access_Professionals
> > http://www.thatlldoit.com
> > Microsoft Office Access MVP
> > https://mvp.support.microsoft.com/profile/Bill.Mosca
> >
> >
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "yshopper" <mossj5@> wrote:
> > >
> > > I need to import an Excel file to my tracking DB and have the imported data match one field in an existing table. The Excel files are the first returned Items and contains the same BibID as what was shipped. The excel file also has other data that I need to have matched with the identical BibIDs in tbl_Items.
> > >
> > > I imported the Excel file into tbl_ItemsURLs w/no problems. I setup a one to one relation between those 2 tables. The BibID fields in both tables are Indexed w/No Duplicates.
> > >
> > > What would be the best way to go about viewing this information? I tried adding both tables to the Query Design grid, added fields from both tables and got a "Type Mismatch in Expression" error.
> > >
> > > Any help would be greatly appreciated.
> > >
> > > Thanks,
> > > John
> > >
> >
>
Tidak ada komentar:
Posting Komentar