link ranges from excel George Walters 25.07.2006 20:51:02 1 I have a range (non contigious cells) defined in excel. When I try to create a linked table in access using this range, the range does not appear as a choice. 2 A more simple task, I thought: I have two identically designed tables. I want to look at all the records in both tables using a query, without creating a table.

Re: link ranges from excel John Nurick <j.mapSoN.nurick[ at ]dial.pipex.com> 25.07.2006 21:14:05 On Tue, 25 Jul 2006 13:51:02 -0700, George Walters <GeorgeWalters[ at ]discussions.microsoft.com> wrote: [Quoted Text] >1 I have a range (non contigious cells) defined in excel. When I try to >create a linked table in access using this range, the range does not appear >as a choice. That's normal. You can't import or link a non-contiguous range. >2 A more simple task, I thought: I have two identically designed tables. I >want to look at all the records in both tables using a query, without >creating a table. Use a UNION query. -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email.

RE: link ranges from excel Klatuu 25.07.2006 21:20:01 "George Walters" wrote: [Quoted Text] > 1 I have a range (non contigious cells) defined in excel. When I try to > create a linked table in access using this range, the range does not appear > as a choice. You can't link to a spreadsheet using non contigious cells. You can define a range if you use the TransferSpreadsheet method, but it must be a contigious range. You could link to the spreadsheet as is, then create a query that included only the columns you want. If it is non contigious row, can't happen at all. > > 2 A more simple task, I thought: I have two identically designed tables. I > want to look at all the records in both tables using a query, without > creating a table. Create a Union query SELECT Table1.* FROM Table1; UNION ALL SELECT Table2.* FROM Table2;