Nah. A year or so doing it full time should do it. But I'm still learning after
16 years.
Regards,
Bill
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Moss
Sent: Wednesday, January 25, 2012 6:46 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Re: Import Excel file and Match Existing Record
That should only take a couple of decades ;)
On 1/25/2012 3:55 PM, Bill Mosca wrote:
>
> 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
<mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>, "yshopper"
> <mossj5@...> wrote:
> >
> > Thanks Bill. I should have checked that before.
> >
> > --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.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
<mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.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
> > > >
> > >
> >
>
>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar