Help Importing Excel spreadsheets

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

Guest

After I import the spreadsheet, all of the information is out of order. All
of the columns are in the correct place, but the original data from the
spreadsheet is in a random order. How do I ensure that when I import it will
keep the data in the correct order? Or, how do I put the data back into the
correct order via Access? There are over 3000 rows, or I would do it by
hand. Thanks!
 
Normally, when you import an Excel file into a new table, the data will stay
in the order it is in the spreadsheet unless you have data names that fall
into the auto index list. The default for that list is - ID;key;code;num - If
you have a field name (column header) that "contains" (ie ProdID), any of
these, then it will create an index for that field.
So, the solution is, either be sure none of your column headers fall into
that list or change the defalut list in Access. Do that from the menu by
Tools->Options, select the Tables/queries tab, and look at Auto Index on
Import/Create:

If you are imorting into an existing table, be sure you have the sort order
set up like you want it.
 
Back
Top