You got to set the format of the column type to text.. As someone else said, Access is much better for such jobs as it retains values as is.. It has got a broader range of functionality that is more SQL like which is easier for us that work with data stored in standard RDBMS’s in case you need to do some mass data cleaning.
Cheers Joe From: Ron Tavares Sent: Wednesday, June 22, 2011 9:30 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Excel frustration with AIE and Data Imports ** Good Morning Listers, You how when you open a .csv file in Excel, Microsoft will do it's magic and start changing the format of certain values? As an example, it will drop the leading zeros form a value because it assumes it is numeric, (like a serial number). So you have to fix the data, format the column as 'text' and save the file. Then, the next time you open the file, the process starts all over again. I know I can use notepad to edit, but that is a pain. So I have two questions: 1) Is there a way to set a preference in Excel to say "Hey! don't do that!" 2) Assuming the answer to question one is no, is there another tool out there that works like Excel but is geared toward developer geeks? Sort of like what Notepad is for Windows, except it would display the data in column/row. I know I would really like a tool like that. Thanks, .ron _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
