link ranges from excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

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.
Click to expand...

Use a UNION query.
 
George Walters said:
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.
Click to expand...
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.
Click to expand...
Create a Union query
SELECT Table1.* FROM Table1;
UNION ALL
SELECT Table2.* FROM Table2;
 
Back
Top