Re: Copy Access Table to SQL
From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 12/06/04
- Next message: Narayana Vyas Kondreddi: "Re: Server Documentation"
- Previous message: Chris: "Index Usage Trace"
- In reply to: Petra: "Copy Access Table to SQL"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 6 Dec 2004 17:43:05 -0000
In SQL Server you don't have to worry about how the data is stored. All you
have to do is to, specify an ORDER BY clause in your queries, to get the
data out in your desired sort order.
-- HTH, Vyas, MVP (SQL Server) SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/ "Petra" <Petra@discussions.microsoft.com> wrote in message news:09506D78-2CFC-4482-AD02-2000131510A2@microsoft.com... Exporting an Access table and saving it as a DTS package copies the table but loses it's column sorting. In the Access table, the "Main Number" is sorted as ascending, but dropping and copying the table via DTS distorts the sort and does not contain a sort sequence, even by ID. What causes this and how can I correct this? Thanks, P
- Next message: Narayana Vyas Kondreddi: "Re: Server Documentation"
- Previous message: Chris: "Index Usage Trace"
- In reply to: Petra: "Copy Access Table to SQL"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
