Re: sorting between two spreadsheets


"David Lloyd" <David@xxxxxxxxxxxxxxxx> wrote in message
news:1F9vf.44017$Lb1.38191@xxxxxxxxxxxxxxxxxxxxxxxxx
> Joe:
>
> I don't have a great deal of information regarding your exact setup,
> however, it appears that you could do an INNER JOIN between the two
> "spreadsheets." An Excel worksheet is limited to about 65536 rows, so I
> am
> assuming your larger data matrix is already in Access. You could link the
> smaller data set which I am assuming is in Excel into Access and then
> perform the INNER JOIN query.
>
> You can link an Excel spreadsheet into Access through the File menu, Get
> External Data, Link Tables option. In the Files of Type drop down, select
> Excel and browse to your workbook. You can then create a query from the
> two
> tables joining them on the appropriate field.

Just one comment to add to David's excellent answer. With lots of data, you
can improve performance by making sure that the columns in the Join are
indexed. To index them, they will have to be imported into Access. If
performance is satisfactory linking to Excel, then don't worry about it.

Larry Linson
Microsoft Access MVP


.

Relevant Pages

  • Re: Left JOINS in multiple table MSQuery in Excel
    ... Your Excel version is using an INNER JOIN (you've reinvented the old ... Excel, it would appear you need to change the tables in your FROM ... I have gotten close, but I have virtually no experience with SQL, and I am guessing that's where the answer lies. ... > At first, I copied the sql from the Access query and pasted into MSQuery to attempt to just duplicate the data there, but ran into a problem. ...
    (microsoft.public.excel.programming)
  • Re: Help please with Update Query
    ... What I'm driving at is that if the email recipient needs, for example, only 3 ... Just make a query (using the above query as the data ... source) with the fields he needs and export that to Excel. ... >FROM (Dealer INNER JOIN (Customers INNER JOIN Orders ON Customers.CustomerID ...
    (microsoft.public.access.queries)
  • Programming SQL with dates in VBA
    ... I'm having some trouble with Excel. ... Dim TABLESQL As String ... 'CREATE TABLE SQL ... ((tblAccounting INNER JOIN (tblProduction INNER JOIN tblBudget ON ...
    (microsoft.public.access.modulesdaovba)
  • Re: Help please with Update Query
    ... FROM (Dealer INNER JOIN (Customers INNER JOIN Orders ON Customers.CustomerID ... >From this query, I analyze with Excel to create the Excel worksheet. ... if the original query is not a totals ...
    (microsoft.public.access.queries)
  • Re: Copy Selection and Append Paste
    ... so everyone hands in an excel spreadsheet (and I don't ... "Ken Snell " wrote: ... <MS ACCESS MVP> ...
    (microsoft.public.access.modulesdaovba)