(Msg. 1) Posted: Thu Aug 28, 2008 1:30 pm
Post subject: Importing Excel workbooks Archived from groups: microsoft>public>access>setupconfig (more info?)
Hello, The setup: I have two excel workbooks with similar but not entirely
identical information. (Both track customer complaints. However, they both
have unique fields [one tracks monetary compensation and the other tracks
response time]). My objective is to combine the two worksheets and to
remove the duplicated information. Is there a way to have access do this for
me? It will take me days to copy and paste each field. Thank you in
advance.
(Msg. 2) Posted: Fri Aug 29, 2008 11:02 am
Post subject: Re: Importing Excel workbooks [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Yes, if there is an ID field that relates both worksheets - import both
worksheets into two seperate tables. Make the field the primary key (ID).
Run a query that appends one table to the other - it will not append the
duplicated ID. If you don't have an ID or something to relate on post what
you do have.
Brendan wrote:
>Hello, The setup: I have two excel workbooks with similar but not entirely
>identical information. (Both track customer complaints. However, they both
>have unique fields [one tracks monetary compensation and the other tracks
>response time]). My objective is to combine the two worksheets and to
>remove the duplicated information. Is there a way to have access do this for
>me? It will take me days to copy and paste each field. Thank you in
>advance.
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other