Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Joining up data points | Charts and Charting in Excel | |||
joining spreadsheets together for reports and queries? | Excel Programming | |||
VB code for joining column data. | Excel Programming | |||
Joining rows with different data | Excel Programming | |||
Compare data of two excel spreadsheets in a third sheet | Excel Programming |