Ordering data in table

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I would like to sort data alphabetically in ascending order based on a
column of names. I am then exporting the data to a SQL database, but when I
do so the data is no longer sorted alphabetically. How do I sort a current
Access database so that it retains the alphabetical sort order when I
transfer the data to a SQL database?
 
Jeff said:
I would like to sort data alphabetically in ascending order based on a
column of names. I am then exporting the data to a SQL database, but when I
do so the data is no longer sorted alphabetically. How do I sort a current
Access database so that it retains the alphabetical sort order when I
transfer the data to a SQL database?

Tables have no inherant order. Any time you need the records exposed in a
particular order you have to create a query or view with the desired ORDER BY
clause.
 
So, how would I order the data and export it with the order I want to
a SQL database?

It really doesn't matter what order you send the stuff to SQLS in, because
the order will be meaningless once it's in the destination table.

When you _read_ it out of the SQL database is when it needs to be ordered!

HTH


Tim F
 
How do I sort a current
Access database so that it retains the alphabetical sort order when I
transfer the data to a SQL database?

By exporting a Query with a sort clause, rather than futilely trying
to sort the "bucket of data" that is a Table.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Jeff

The consensus of the answers to you question seems to be that it doesn't
matter what order you send out the data. If you want data that you have
stored in a SQL database to display in any particular order, you have to do
the sorting THERE.
 
Back
Top