RE: [ACFUG Discuss] Off Topic: MS Excel Sort Corrupts Mass Data.

[Robert Reil]

Cody YOU GOT IT!!!!   I explained this to the PM we met with last week and he knew exactly what I was talking about and said you cant do that or it will corrupt data! Now you tell me? I explained it to a friend and he said AUTO FILTER. I remember you said that also but have not had the chance to get back into it since then.   Just tried that, and the friend has been an EXCEL user for about 15 years now straight and feels very comfortable with AUTO FILTER doing the job.   I like it, it seems to work (better than sort!) fine.   Thanks all, Just thought you would like to know what I learned.   Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com From: Cody Wehunt [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 18, 2006 8:07 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] Off Topic: MS Excel Sort Corrupts Mass Data.   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 Sent: Friday, June 16, 2006 2:32 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] Off Topic: MS Excel Sort Corrupts Mass Data.   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 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com From: Teddy Payne [mailto:[EMAIL PROTECTED] Sent: Thursday, June 15, 2006 5:30 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Off Topic: MS Excel Sort Corrupts Mass Data.   If your are exporting, why not sort it prior to the export?  Let the database do the sorting for you. I would store the data for the export into a transition table that is truncated prior to every export.  You insert the data into in the sort order that you need and then export the data into excel from there. Have the database keep integrity and not depend on the spreadsheet.  The data may not be stored as unicode and leading data on certain columns may be omitted, especially numbers with leading 0s. Teddy On 6/15/06, Robert Reil <[EMAIL PROTECTED]> wrote: 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. Some of these columns host full html data. The problem is that while managing this data while integrating a large amount of rows into the csv we sometimes have to sort by column. We have done this both by using the A/Z sort button short cut, and by clicking the upper left box where all cells get highlighted, clicking Data, then Sort, and choosing appropriate columns to sort by. Sometimes we hide columns in order to manage 40 columns of data. However from time to time in a manner we can not yet duplicate or determine (though we have a suspision that it is hidden data) we find that data that was was not sorted even though we choose to have all fields sorted becomes disassociated with it's respective row and the data ends up being corrupted. Though this is not to say that we are sure that hidding data is even relevent. Has anyone seen this behavior? Is there a fix, or switch, or different tool we should be using to do mass sorting, and resorting without fear of loosing data integrity?   Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw , Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com -- <cf_payne /> ------------------------------------------------------------- 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 ------------------------------------------------------------- ------------------------------------------------------------- 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 -------------------------------------------------------------