Re: Excel frustration with AIE and Data Imports

2011-06-30 Thread Theo Fondse
Try not to become a person of success, but a person of value. - Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ron Tavares Sent: 29 June 2011 21:20 To: arslist@ARSLIST.ORG Subject: Re: Excel frustration with AIE and Data Imports

Re: Excel frustration with AIE and Data Imports

2011-06-29 Thread Ron Tavares
] *On Behalf Of *Ron Tavares *Sent:* 22 June 2011 15:31 *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

Excel frustration with AIE and Data Imports

2011-06-22 Thread Ron Tavares
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,

Re: Excel frustration with AIE and Data Imports

2011-06-22 Thread Grooms, Frederick W
I've used Access for things like that -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ron Tavares Sent: Wednesday, June 22, 2011 8:31 AM To: arslist@ARSLIST.ORG Subject: Excel frustration with AIE and Data Imports

Re: Excel frustration with AIE and Data Imports

2011-06-22 Thread Lucero, Michelle
Subject: Re: Excel frustration with AIE and Data Imports I've used Access for things like that -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ron Tavares Sent: Wednesday, June 22, 2011 8:31 AM To: arslist@ARSLIST.ORG Subject

Re: Excel frustration with AIE and Data Imports

2011-06-22 Thread Joe Martin D'Souza
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

Re: Excel frustration with AIE and Data Imports

2011-06-22 Thread Theo Fondse
(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ron Tavares Sent: 22 June 2011 15:31 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