Access Records into Excel

  • Thread starter Thread starter KJGradwell
  • Start date Start date
K

KJGradwell

Guys
I wonder if any one can help me? When I export from Access to Excel I'm OK
when I import into Excel I am not.
Specifically;
when I import (via external data) a table from Access the records are
largely in the correct order but not completely so, occasional records or
small groups of records are out of sync.
If I open the data from Access (tools-microsoft office-analyse in excel) the
records are displayed in sequence. I need to be able to refresh the excel
file as records are added to access; so as far as I know importing into
excel is the way to do it but I'm a bit stuck.

Thanks
Kevan
 
Hi Kevan,

One of the goals of a true database is to enable records to appear in any
sequence, and so at times they do. Unless your table is indexed and the
index is in effect, when you open the table in Access, you'll usually but
not necessarily see the records in the order entered.

My own preference is to build an Access query, cause it to sort on the
field(s) I want for my sequence, and then point my external data range at
that query. I prefer that approach because I often bring back to Excel data
from linked tables, and Access gives me greater control over queries than
does Microsoft Query.

And yes, external data ranges (or pivot tables) are the way to go, unless
you have to do record-by-record processing, in which case you should
probably resort to VBA and ADO.
 
Thanks Conrad
I'll have a go.
Kevan
Conrad Carlberg said:
Hi Kevan,

One of the goals of a true database is to enable records to appear in any
sequence, and so at times they do. Unless your table is indexed and the
index is in effect, when you open the table in Access, you'll usually but
not necessarily see the records in the order entered.

My own preference is to build an Access query, cause it to sort on the
field(s) I want for my sequence, and then point my external data range at
that query. I prefer that approach because I often bring back to Excel
data
from linked tables, and Access gives me greater control over queries than
does Microsoft Query.

And yes, external data ranges (or pivot tables) are the way to go, unless
you have to do record-by-record processing, in which case you should
probably resort to VBA and ADO.
--
C^2
Conrad Carlberg

Excel Sales Forecasting for Dummies, Wiley, 2005
Click to expand...
 
Back
Top