View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Versie Versie is offline
external usenet poster
 
Posts: 3
Default Joining data from 2 spreadsheets into 1 sheet

I am trying to join 2 spdshts and pull just certain info from each one. One
is a query that I pulled from an Access table and put in Excel. The other is
an Excel spreadsheet. I am using the employee id as my primary key to join
the sheets. I verifies that both of the columns were formatted the same. When
I try to join the tables I get the message: 'Columns eeid and eeid that you
are about to join are of different types. Create the join anyway?' If I say
'yes' it lets me add the column headings but then returns nothing. If I say
no, it closes it down. When I click 'help' I get a blank screen to look
at.......
any ideas or suggestions out there?????


--
Thanks for your help!
Have a blessed day.