[AccessD] Exporting to .txt

never mind, done

> Just one more little thing;
> There is a field "hours" which when gets transferred to .txt putes . at
> the end of numers like 60. or 70.
> I'd like to avoid it, i change datatype to text in the table, but result
> is the same. Should I do something in the query for it also ?
>
>
>> SELECT SSN, Format([PayDate], "mmddyyyy"), Format([PeriodEndDate],
>> "mmddyyyy"
>> FROM op_TALX
>>
>> Charlotte Foust
>>
>> -----Original Message-----
>> From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com]
>> Sent: Friday, December 12, 2003 9:43 AM
>> To: accessd at databaseadvisors.com
>> Subject: RE: [AccessD] Exporting to .txt
>>
>>
>> Where can I do format ? in sql window of query ?
>>
>> SELECT SSN, PayDate, PeriodEndDate
>> FROM op_TALX
>>
>> here ?
>>
>>> You need to do the export from a query and use the format function to
>>> change the date to a string of the correct format.  If you just
>>> export
>>
>>> from the table, a date is going to be handled as a date.
>>>
>>> Charlotte Foust
>>>
>>> -----Original Message-----
>>> From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com]
>>> Sent: Friday, December 12, 2003 9:05 AM
>>> To: accessd at databaseadvisors.com
>>> Subject: [AccessD] Exporting to .txt
>>>
>>>
>>> I need to export a file to either .scv or .txt format with fixed
>>> length. There are 2 date fields which should be in a mmddyyyy format.
>>> I specify in 'specification' that field should have be in a format
>>> MDY, 4 digit year. leading zeros, no dividers, yet I still get
>>> 12/7/2003 type results... in txt file..
>>>
>>>
>>> -----------------------------------------
>>> Get Breaking News from CNN, ABC, NBC, CBS Now.
>>> http://www.xuppa.com/news/?link=webmail
>>>
>>>
>>> _______________________________________________
>>> AccessD mailing list
>>> AccessD at databaseadvisors.com
>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>> Website: http://www.databaseadvisors.com
>>> _______________________________________________
>>> AccessD mailing list
>>> AccessD at databaseadvisors.com
>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>> Website: http://www.databaseadvisors.com
>>
>>
>>
>> -----------------------------------------
>> Get Breaking News from CNN, ABC, NBC, CBS Now.
>> http://www.xuppa.com/news/?link=webmail
>>
>>
>> _______________________________________________
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>> _______________________________________________
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>
>
>
>
>
>
>
>
>
> -----------------------------------------
> Get Breaking News from CNN, ABC, NBC, CBS Now.
> http://www.xuppa.com/news/?link=webmail
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



-----------------------------------------
Get Breaking News from CNN, ABC, NBC, CBS Now.
http://www.xuppa.com/news/?link=webmail