I think you should look into filter’s
into excel if I understand your problem correctly. Cody From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Robert
Reil Well we do that when appropriate but
sometimes we have so much organization to do that we sort this column this way and
make appropriate mods by populating a cell and copying by dragging the little
plus sign down till the appropriate items are populated. Then we resort in another way and do the
same. Some times we need to have a numerical autonumber, then resort again.
Etc. The problem is that when data arrives as
new products we have it as a csv, and have to populate approximately 35 more
columns before we can push it to the table in the DB. If we have a thousand products to do this
to it take a while and the most efficient way is to keep sorting it as
appropriate. I understand if my SQL coding skills were
better (I have none and just read a quick tutorial on it) I may be able to do
things better. But for now Excel seems like the only solution and it does not
work as data keeps getting corrupted. ARGHHHHH!!!!!!!!!!! Robert P. Reil Managing Director, Motorcyclecarbs.com,
Inc. 4292 Office 770-974-8851 Fax 770-974-8852 From: Teddy Payne
[mailto:[EMAIL PROTECTED] If your are exporting,
why not sort it prior to the export? Let the database do the sorting for
you. On 6/15/06, Any one
there have skills or work with someone who has heavy Excel skills that can
answer this? I have searched google for 2 hours for a solution. Can find none. I have to
do a csv export of our database table which equates to 9000 rows by abou 40
columns. Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Office 770-974-8851 Fax 770-974-8852
------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink ------------------------------------------------------------- |
- RE: [ACFUG Discuss] Off Topic: MS Excel Sort Corrupts Mass Dat... Cody Wehunt