Mixing lists

U

Usarian

I had this identical problem doing this in Access as well.

I copy/pasted two CSV lists into an Excel file, one
preceeding the other. Both list state, as well as
several other columns of information which represent
which company owns the item on that row, and the ID that
company uses for the item.

I cannot Query Access or sort in Excel the combined list
by state. The result I get is two consecutive lists
sorted by state. I need to merge these two lists into an
Access database file. Please Help!

Usarian M. Skiff
 
J

JulieD

Hi

a couple of ideas:

ensure that "state" is in the same column in both lists?
make sure that there are no blank rows betwen the two lists
ensure that you're selecting the complete list and choosing Data / Sort when
trying to sort them

if that fails then it means there are differences in how state is entered in
the two lists ... look for leading & trailing spaces (add in a new column to
the right of your existing column, type
=TRIM(D2)
where D2 is the first state entry in the list and copy down the whole list,
now use copy / edit - paste special - values
to convert this new column to a new state column - give it a heading in row
1 (if your other data has headings in row 1) , select the whole range,
choose data / sort & try again.

let us know how you get on.

Cheers
JulieD
 
Top