Hello Group I did ask this in a ticket. I am not asking here again to bother the support people, I am only asking if someone already has the answer. Plese know offense to the great support we have. I have a xls sheet that has leading zeros for the member number and of course zip codes for the northeast have leading zeros. How do I get this informaiton into the member script? I have 999 members with leading zeros as their member number. I do not want to change all of these manually. I do want to offend the support team by posting here and the ticket center. Just hoping to get a users ideas on the matter.
The Problem is solved If you are using Access for the main DB you have to export the file and save it as a txt file. Microsoft will ALWAYS delete the leading zeros. So a CSV file is useless for zip codes in the Northeast. It took me 24 hours to figure this out, Without this board to type to I would have never found the answer. I may not be a leading zero but I do know how to deal with them now!
Well, I bevieve it is possible to specify during CSV import that field type is "text" then nor excel, nor access should not touch zeros.
YES, you are correct but I have to import it into aMember as a text file not csv or I will loose the leading zero. I think I have this correct.
One More thing If you export it as a csv and open it as a csv your information is lost. Because when you open the data Excel is not going to ask you about the fields. When you dowload it to your computer you have to change the file to a txt file then open it with Excel. At that point change the fields (zipcode, member id) to text and you will not loose the leading zero. The file should be able to be downloaded to my computere as a comma seperated text file with a file extension as .txt This is only my humble opinion but now I know how the program works it does not matter. It only took me a while on how to deal with the leading zero. Which now I can say I am an expert in the zero field.