[AccessD] Exporting to .txt

Charlotte Foust cfoust at infostatsystems.com
Fri Dec 12 13:15:43 CST 2003


Sorry, but you don't have "hours" in your SQL, so I'm not sure what
you're trying to do with it.  What happens at the end of numbers like 60
or 70?

Charlotte Foust

-----Original Message-----
From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com] 
Sent: Friday, December 12, 2003 10:29 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Exporting to .txt


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


More information about the AccessD mailing list