That's about right. I've been working with Access since 1991.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Lahaina, HI)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Moss
Sent: Wednesday, January 25, 2012 4: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>, "yshopper"
> <mossj5@...> wrote:
> >
> > Thanks Bill. I should have checked that before.
> >
> > --- In MS_Access_Professionals@yahoogroups.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>, "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]
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar