Importing from MS Access problems

  • Thread starter Thread starter Margaret Couch
  • Start date Start date
M

Margaret Couch

Can anyone offer ideas about why data exported from Access is opening in
Excel out of order on the spreadsheet? The data is a list of school
admissions over several years. When exported to excel some of the entires
are appearing out of date order. Thanks
MArgaret
 
If data appears in order within an Access database it is probably because
the date field is keyed, i.e., no matter in what order data is added it will
always appear in date order.

When that data is imported into another program, such as Excel, the "key" is
not imported and the data will appear in the order in which it was
originally entered.

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
 
Back
Top