469,289 Members | 2,202 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,289 developers. It's quick & easy.

Problem with "dates" using TransferText

Hello,

I have a possible problem exporting a text field that happens to
contain dates (but is not a date field) when using TransferText in MS
Access 2000.

I am exporting a query to a text file using TransferText in a module.
One of my fields is a text field called "invoice description". This
field may include any content including dates (e.g., 01/01/2006,
1/1/2006, 01/01/06, Invoice #1, Jan 2006, 293842, etc. are all
possible values). These values come directly from an invoice.

When I export the data, on my own computer the text in this field
appears fine in the output file (exactly as entered in Access).

When my client exports the data, on her computer the text in this
field for the most part is OK, but for those records with what appear
to be dates as the value, she claims that her output file shows
certain date conversions (e.g. "01/01/06" becomes "01/01/2006", and
"11-2005" becomes "05-Nov"). This is problematic for her, as the
output should show the actual text that was entered.

My questions are:

1. Has anyone experienced this issue, or does it at least seem
plausible that it could occur on one computer and not another?

2. Is there any way to fix this problem? I have tried to think about
possible changes to formats in the table or query, or in the export
file specification, but I don't think these would fix the problem. I
suspect it may be a "client side" issue outside of MS Access?

Thanks for any help you can provide.

Dave

Sep 23 '07 #1
5 1885
On Sun, 23 Sep 2007 15:16:53 -0700, Dave <in**@songindex.orgwrote:

How is she viewing the output file?
For example if it were in Excel, that program would try to be helpful
and format values the way it was not intended. Let her view the file
in Notepad.

-Tom.

>Hello,

I have a possible problem exporting a text field that happens to
contain dates (but is not a date field) when using TransferText in MS
Access 2000.

I am exporting a query to a text file using TransferText in a module.
One of my fields is a text field called "invoice description". This
field may include any content including dates (e.g., 01/01/2006,
1/1/2006, 01/01/06, Invoice #1, Jan 2006, 293842, etc. are all
possible values). These values come directly from an invoice.

When I export the data, on my own computer the text in this field
appears fine in the output file (exactly as entered in Access).

When my client exports the data, on her computer the text in this
field for the most part is OK, but for those records with what appear
to be dates as the value, she claims that her output file shows
certain date conversions (e.g. "01/01/06" becomes "01/01/2006", and
"11-2005" becomes "05-Nov"). This is problematic for her, as the
output should show the actual text that was entered.

My questions are:

1. Has anyone experienced this issue, or does it at least seem
plausible that it could occur on one computer and not another?

2. Is there any way to fix this problem? I have tried to think about
possible changes to formats in the table or query, or in the export
file specification, but I don't think these would fix the problem. I
suspect it may be a "client side" issue outside of MS Access?

Thanks for any help you can provide.

Dave
Sep 24 '07 #2
On Sep 23, 11:25 pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On Sun, 23 Sep 2007 15:16:53 -0700, Dave <i...@songindex.orgwrote:

How is she viewing the output file?
For example if it were in Excel, that program would try to be helpful
and format values the way it was not intended. Let her view the file
in Notepad.

-Tom.
Hello,
I have a possible problem exporting a text field that happens to
contain dates (but is not a date field) when using TransferText in MS
Access 2000.
I am exporting a query to a text file using TransferText in a module.
One of my fields is a text field called "invoice description". This
field may include any content including dates (e.g., 01/01/2006,
1/1/2006, 01/01/06, Invoice #1, Jan 2006, 293842, etc. are all
possible values). These values come directly from an invoice.
When I export the data, on my own computer the text in this field
appears fine in the output file (exactly as entered in Access).
When my client exports the data, on her computer the text in this
field for the most part is OK, but for those records with what appear
to be dates as the value, she claims that her output file shows
certain date conversions (e.g. "01/01/06" becomes "01/01/2006", and
"11-2005" becomes "05-Nov"). This is problematic for her, as the
output should show the actual text that was entered.
My questions are:
1. Has anyone experienced this issue, or does it at least seem
plausible that it could occur on one computer and not another?
2. Is there any way to fix this problem? I have tried to think about
possible changes to formats in the table or query, or in the export
file specification, but I don't think these would fix the problem. I
suspect it may be a "client side" issue outside of MS Access?
Thanks for any help you can provide.
Dave- Hide quoted text -

- Show quoted text -
She sent me her output of the file and when I open it in Notepad the
formatting is how she described (i.e., the dates are different from
when I create the output file).

It could be that she modified it in Excel first and re-saved it as a
text file, then maybe that is how things could have changed. I will
ask today.

Otherwise any other ideas are welcome....

Thanks
Dave

Sep 24 '07 #3
On Sep 23, 6:16 pm, Dave <i...@songindex.orgwrote:
Thanks for any help you can provide.
If I were doing this I would use a regular expression to translate
strings in the form of
99/99/9999 or 99/99/99 to dates that everyone could understand:
9999-99-99.

And if I weren't so busy right now I'd "right" one because it might be
useful to have in the old repertoire. Of course, such an animal may be
lurking on the net.

Sep 24 '07 #4
Indeed. Is this it?

'-------------------------------------------------------
Function IsoDate(dteDate)
'-------------------------------------------------------
'Version 1.0 by Giuliano Sauro
If IsDate(dteDate) = True Then
Dim dteDay, dteMonth, dteYear
dteDay = Day(dteDate)
dteMonth = Month(dteDate)
dteYear = Year(dteDate)
IsoDate = dteYear & _
"-" & right(CStr(dteMonth + 100), 2) & _
"-" & right(CStr(dteDay + 100), 2)
Else
IsoDate = Null
End If
End Function
On Mon, 24 Sep 2007 13:37:30 -0000, lyle <ly************@gmail.com>
wrote:
>Of course, such an animal may be
lurking on the net.
Sep 24 '07 #5
On Sep 23, 11:25 pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On Sun, 23 Sep 2007 15:16:53 -0700, Dave <i...@songindex.orgwrote:

How is she viewing the output file?
For example if it were in Excel, that program would try to be helpful
and format values the way it was not intended. Let her view the file
in Notepad.

-Tom.
Hello,
I have a possible problem exporting a text field that happens to
contain dates (but is not a date field) when using TransferText in MS
Access 2000.
I am exporting a query to a text file using TransferText in a module.
One of my fields is a text field called "invoice description". This
field may include any content including dates (e.g., 01/01/2006,
1/1/2006, 01/01/06, Invoice #1, Jan 2006, 293842, etc. are all
possible values). These values come directly from an invoice.
When I export the data, on my own computer the text in this field
appears fine in the output file (exactly as entered in Access).
When my client exports the data, on her computer the text in this
field for the most part is OK, but for those records with what appear
to be dates as the value, she claims that her output file shows
certain date conversions (e.g. "01/01/06" becomes "01/01/2006", and
"11-2005" becomes "05-Nov"). This is problematic for her, as the
output should show the actual text that was entered.
My questions are:
1. Has anyone experienced this issue, or does it at least seem
plausible that it could occur on one computer and not another?
2. Is there any way to fix this problem? I have tried to think about
possible changes to formats in the table or query, or in the export
file specification, but I don't think these would fix the problem. I
suspect it may be a "client side" issue outside of MS Access?
Thanks for any help you can provide.
Dave- Hide quoted text -

- Show quoted text -
Hi Tom, so I think that you are probably right re: Excel. Thanks for
the suggestion.

Dave

Sep 25 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Fons Dijkstra | last post: by
6 posts views Thread by Bill R via AccessMonster.com | last post: by
4 posts views Thread by cheryl | last post: by
9 posts views Thread by clintonb | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.