Re: Problem with CSV Date column
- From: "Bill Nguyen" <billn_nospam_please@xxxxxxxx>
- Date: Tue, 20 Mar 2007 16:31:53 -0700
VJ;
leading zero in Item(15) was removed during the reading process.
Please review the attached CSV file
Thanks
Bill
------------
Dim csvConnection As OdbcConnection
Dim ConnectionString As String = "Driver={Microsoft Text Driver (*.txt;
*.csv)};Dbq=" & _
mcsvPath & ";"
Try
' Create connection to folder containing CSV file
csvConnection = New OdbcConnection(ConnectionString)
csvConnection.Open()
Dim csvCommand As OdbcCommand
Dim csvReader As OdbcDataReader
Try
' Select all rows from the
csvCommand = csvConnection.CreateCommand()
csvCommand.CommandText = "select * from " & mcsvDoc
csvCommand.CommandType = CommandType.Text
' Use a reader to iterate through the rows
csvReader = csvCommand.ExecuteReader()
If csvReader.Read() Then
Do
If IsDBNull(csvReader.Item(15)) = False Then
mShipDate = csvReader.Item(15)
' mShipdate2 = CDate(csvReader.Item(15))
Else
mShipDate = "NA"
End If
If IsDBNull(csvReader.Item(16)) = False Then
mShipTime = csvReader.Item(16)
Else
mShipTime = "NA"
End If
"VJ" <nonewsaddress@xxxxxxxxx> wrote in message
news:%23vkC2izaHHA.3960@xxxxxxxxxxxxxxxxxxxxxxx
Bill, if you could post a short example of your problem code , along with
only line of data from text file. I will try to help
VJ
"Bill Nguyen" <billn_nospam_please@xxxxxxxx> wrote in message
news:%23hbEIazaHHA.4808@xxxxxxxxxxxxxxxxxxxxxxx
Rich;
Thanks but this is propbably not the solution.
I need the data to be in text format (with leading zero) so that I can
convert it into a date field.
Thanks again
Bill
"Rich" <Rich@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2690EC81-9053-4FA1-BB29-8C847CBFF643@xxxxxxxxxxxxxxxx
Greetings,
Try reading your data this way:
Imports System.Data.OleDb
Imports System.Data
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
Dim da As OleDbDataAdapter, ds As DataSet, conn As
OleDbConnection
conn = New OleDbConnection
conn.ConnectionString = "provider=Microsoft.Jet.OLEDB.4.0;data
source=C:\bin\test1.xls;Extended Properties=Excel 8.0"
da = New OleDbDataAdapter
ds = New DataSet
da.SelectCommand = New OleDbCommand
da.SelectCommand.Connection = conn
da.SelectCommand.CommandText = "Select * From [SubscribersList$]"
da.Fill(ds, "tbl1")
dgrv1.DataSource = ds.Tables("tbl1")
End Sub
My test Excel file included a date field, and the dates displayed
correctly
in the datagridview.
hth
Rich
"Bill Nguyen" wrote:
I'm reading a CSV file with the date colum formatted as "YYMMDD" ->
"070310"
when viewed in notepad or similar trext editor.
However, in my app, using ODBCReader, the column value becomes "70310"
(integer value). This invalidates my attempt to convert the field into
a
date field. I notice that this happened to other columns as well.
Is there a way to keep the original format (or to convert into date
field
for this column?
Thanks
Bill
begin 666 0005400192_20070309.csv
M,# P-C U."PP,# P,# P,# Q+# P,# Q,#8Y-SDL,# P,# Q-S,L,# P-30P
M,#$Y,BQ72$],+%=(3TQ%4T%,12!&545,4RQ'3D<P.#,L54Q44D$@3%,@0T%2
M0B!$4TP@,34@4%!-+$<L,3 S-3,V+" @,S@N,RP@(#<U+C L,# P,# W-3 P
M+# P,# P-S0T-RPP-S S,#@L,# U.2PL#0HP,# V,#4X+# P,# P,# P,#$L
M,# P,#$P-CDX-"PP,# P,#0X-2PP,# U-# P,3DR+$)42U(L,D(@5%)50TM)
M3D<L1TY',#@S+%5,5%)!($Q3($-!4D(@1%-,(#$U(%!032Q'+#8X,3,T+" @
M,S@N,RP@(#<Q+C@L,# P,# R-# P+# P,# P,C,X-RPP-S S,#@L,#$S,RPL
M#0HP,# V,#4X+# P,# P,# P,#$L,# P,#$P-CDX-"PP,# P,#0X-2PP,# U
M-# P,3DR+$)42U(L,D(@5%)50TM)3D<L1TY2,#(W+%)53#@W($-!4D(@151/
M2" U+C<L1RPV.#$S-"P@(#8Q+C0L(" V-2XX+# P,# P-#,U,"PP,# P,#0S
M,S,L,#<P,S X+# Q,S,L+ T*,# P-C U."PP,# P,# P,# Q+# P,# Q,#8Y
M.#0L,# P,# T.#4L,# P-30P,#$Y,BQ"5$M2+#)"(%1254-+24Y'+$=.43 S
M-2Q054PY,2!#05)"($543T@@-2XW+$<L-C@Q,S0L(" V,2XU+" @-3DN,BPP
M,# P,#$X,# L,# P,# Q.# Q+# W,#,P."PP,3,S+"P-"C P,#8P-3@L,# P
M,# P,# P,2PP,# P,3 V.3@U+# P,#4U,C,U+# P,#4T,# Q.3(L5TA/3"Q7
M2$],15-!3$4@1E5%3%,L1TY1,#,U+%!53#DQ($-!4D(@151/2" U+C<L1RPV
M.#$T,BP@(#8Q+C8L(" U.2XQ+# P,# P,#DU,"PP,# P,# Y-3$L,#<P,S X
M+# Q,S0L+ T*,# P-C U."PP,# P,# P,# Q+# P,# Q,#8Y.#4L,# P-34R
M,S4L,# P-30P,#$Y,BQ72$],+%=(3TQ%4T%,12!&545,4RQ'3D<P.#,L54Q4
M4D$@3%,@0T%20B!$4TP@,34@4%!-+$<L-C@Q-#(L(" S."XS+" @-S$N.2PP
M,# P,#(P,# L,# P,# Q.3@Y+# W,#,P."PP,3,T+"P-"C P,#8P-3@L,# P
M,# P,# P,2PP,# P,3 V.3@U+# P,#4U,C,U+# P,#4T,# Q.3(L5TA/3"Q7
M2$],15-!3$4@1E5%3%,L1TY2,#(W+%)53#@W($-!4D(@151/2" U+C<L1RPV
M.#$T,BP@(#8Q+C0L(" V-BXP+# P,# P-C P,"PP,# P,#4Y-S4L,#<P,S X
M+# Q,S0L+ T*,# P-C U."PP,# P,# P,# Q+# P,# Q,#8Y.34L,# P-34R
M,S4L,# P-30P,#$Y,BQ72$],+%=(3TQ%4T%,12!&545,4RQ'3D<P.#,L54Q4
M4D$@3%,@0T%20B!$4TP@,34@4%!-+$<L-C@Q,C@L(" S."XS+" @-C@N,BPP
M,# P,#$P,# L,# P,# P.3DV+# W,#,P."PP,C0R+"P-"C P,#8P-3@L,# P
M,# P,# P,2PP,# P,3 V.3DU+# P,#4U,C,U+# P,#4T,# Q.3(L5TA/3"Q7
M2$],15-!3$4@1E5%3%,L1TY2,#(W+%)53#@W($-!4D(@151/2" U+C<L1RPV
M.#$R."P@(#8Q+C0L(" V-BXP+# P,# P-#0P,"PP,# P,#0S.#$L,#<P,S X
M+# R-#(L+ T*,# P-C U."PP,# P,# P,# Q+# P,# Q,#8Y.34L,# P-34R
M,S4L,# P-30P,#$Y,BQ72$],+%=(3TQ%4T%,12!&545,4RQ'3E(P,C<L4E5,
M.#<@0T%20B!%5$]((#4N-RQ'+#8X,3(X+" @-C$N-"P@(#8T+C<L,# P,# S
M-# P+# P,# P,S,X.2PP-S S,#@L,#(T,BPL#0HP,# V,#4X+# P,# P,# P
M,#$L,# P,#$P-S R,2PP,# Y.#4W.2PP,# U-# P,3DR+%=(3TPL5TA/3$53
M04Q%($9514Q3+$=.1S X,BQ53%1202!,4R!#05)"($19140@1%-,(#$U(%!0
M32Q'+#$P-#4T,RP@(#,X+C,L(" W-"XR+# P,# P,34U,"PP,# P,#$U-# L
M,#<P,S X+# T-38L+ T*,# P-C U."PP,# P,# P,# Q+# P,# Q,#<P,C$L
M,# P.3@U-SDL,# P-30P,#$Y,BQ72$],+%=(3TQ%4T%,12!&545,4RQ'3D<P
M.#,L54Q44D$@3%,@0T%20B!$4TP@,34@4%!-+$<L,3 T-30S+" @,S@N,RP@
M(#8W+C L,# P,# P-C4P+# P,# P,#8T."PP-S S,#@L,#0U-BPL#0HP,# V
M,#4X+# P,# P,# P,#$L,# P,#$P-S R,2PP,# Y.#4W.2PP,# U-# P,3DR
M+%=(3TPL5TA/3$5304Q%($9514Q3+$=.1S X,RQ53%1202!,4R!#05)"($13
M3" Q-2!04$TL1RPQ,#0U-#,L(" S."XS+" @-C4N-BPP,# P,# X,# L,# P
M,# P-SDX+# W,#,P."PP-#4V+"P-"C P,#8P-3@L,# P,# P,# P,2PP,# P
M,3 W,#(R+# P,#DX-3<Y+# P,#4T,# Q.3(L5TA/3"Q72$],15-!3$4@1E5%
M3%,L1TY2,#(W+%)53#@W($-!4D(@151/2" U+C<L1RPQ,#0U-#,L(" V,2XT
M+" @-C,N."PP,# P,#$W,3$L,# P,# Q-S V+# W,#,P."PP-3$Q+"P-"C P
M,#8P-3@L,# P,# P,# P,2PP,# P,3 W,#(W+# P,#DX-3<Y+# P,#4T,# Q
M.3(L5TA/3"Q72$],15-!3$4@1E5%3%,L1TY2,#(W+%)53#@W($-!4D(@151/
M2" U+C<L1RPV.#$U,"P@(#8Q+C0L(" V-2XW+# P,# P,S$P,"PP,# P,#,P
M.#@L,#<P,S X+# U,C$L+ T*,# P-C U."PP,# P,# P,# Q+# P,# Q,#<P
M,S4L,# P-34Q-3<L,# P-30P,#$Y,BQ"5$M2+#)"(%1254-+24Y'+$=.1S X
M,RQ53%1202!,4R!#05)"($133" Q-2!04$TL1RPQ,#,U,CDL(" S."XS+" @
M-S8N,"PP,# P,#,V,# L,# P,# S-3<S+# W,#,P."PP-34X+"P-"C P,#8P
M-3@L,# P,# P,# P,2PP,# P,3 W,#,U+# P,#4U,34W+# P,#4T,# Q.3(L
M0E1+4BPR0B!44E5#2TE.1RQ'3D<P.#,L54Q44D$@3%,@0T%20B!$4TP@,34@
M4%!-+$<L,3 S-3(Y+" @,S@N,RP@(#<V+CDL,# P,# S.3 P+# P,# P,S@V
M."PP-S S,#@L,#4U."PL#0HP,# V,#4X+# P,# P,# P,#$L,# P,#$P-S T
M,2PP,# Y.#8V-BPP,# U-# P,3DR+%=(3TPL5TA/3$5304Q%($9514Q3+$=.
M1S X,BQ53%1202!,4R!#05)"($19140@1%-,(#$U(%!032Q'+#$P,S4T,BP@
M(#,X+C,L(" W-2XP+# P,# P,C U,"PP,# P,#(P,S4L,#<P,S X+# V,#<L
M+ T*,# P-C U."PP,# P,# P,# Q+# P,# Q,#<P-#$L,# P.3@V-C8L,# P
M-30P,#$Y,BQ72$],+%=(3TQ%4T%,12!&545,4RQ'3D<P.#,L54Q44D$@3%,@
M0T%20B!$4TP@,34@4%!-+$<L,3 S-30R+" @,S@N,RP@(#<V+C<L,# P,# P
M.3 P+# P,# P,#@Y,RPP-S S,#@L,#8P-RPL#0HP,# V,#4X+# P,# P,# P
M,#$L,# P,#$P-S T-RPP,# Y.#8R-RPP,# U-# P,3DR+%=(3TPL5TA/3$53
M04Q%($9514Q3+$=.1S X,BQ53%1202!,4R!#05)"($19140@1%-,(#$U(%!0
M32Q'+#$P,S4T-2P@(#,X+C,L(" W-BXU+# P,# P,S8P,"PP,# P,#,U-S(L
M,#<P,S X+# V,C0L+ T*,# P-C U."PP,# P,# P,# Q+# P,# Q,#<P-#@L
M,# P.3@V-C8L,# P-30P,#$Y,BQ72$],+%=(3TQ%4T%,12!&545,4RQ'3E(P
M,C<L4E5,.#<@0T%20B!%5$]((#4N-RQ'+#$P,S4T,BP@(#8Q+C0L(" V,RXY
M+# P,# P,3,U,"PP,# P,#$S-#8L,#<P,S X+# V,C4L+ T*,# P-C U."PP
M,# P,# P,# Q+# P,# Q,#<P-3 L,# P.3@V-C8L,# P-30P,#$Y,BQ72$],
M+%=(3TQ%4T%,12!&545,4RQ'3E(P,C<L4E5,.#<@0T%20B!%5$]((#4N-RQ'
M+#8X,30X+" @-C$N-"P@(#8T+C$L,# P,# S,# R+# P,# P,CDY-"PP-S S
M,#@L,#8S-BPL#0HP,# V,#4X+# P,# P,# P,#$L,# P,#$P-S U-"PP,# Y
M.#8R-RPP,# U-# P,3DR+%=(3TPL5TA/3$5304Q%($9514Q3+$=.4C R-RQ2
M54PX-R!#05)"($543T@@-2XW+$<L,3 S-30U+" @-C$N-"P@(#8S+C@L,# P
M,# P-S P+# P,# P,#8Y."PP-S S,#@L,#8T-"PL#0HP,# V,#4X+# P,# P
M,# P,#$L,# P,#$P-S U-BPP,# Y.#@W-"PP,# U-# P,3DR+%=(3TPL5TA/
M3$5304Q%($9514Q3+$=.1S X,BQ53%1202!,4R!#05)"($19140@1%-,(#$U
M(%!032Q'+#$P,S4T,2P@(#,X+C,L(" W-2XT+# P,# P,#DU,"PP,# P,# Y
M-#,L,#<P,S X+# V-#DL+ T*,# P-C U."PP,# P,# P,# Q+# P,# Q,#<P
M-38L,# P.3@X-S0L,# P-30P,#$Y,BQ72$],+%=(3TQ%4T%,12!&545,4RQ'
M3D<P.#(L54Q44D$@3%,@0T%20B!$645$($133" Q-2!04$TL1RPQ,#,U-#$L
M(" S."XS+" @-S0N-RPP,# P,#0P,# L,# P,# S.3<R+# W,#,P."PP-C0Y
M+"P-"C P,#8P-3@L,# P,# P,# P,2PP,# P,3 W,#4V+# P,#DX.#<T+# P
M,#4T,# Q.3(L5TA/3"Q72$],15-!3$4@1E5%3%,L1TY',#@S+%5,5%)!($Q3
M($-!4D(@1%-,(#$U(%!032Q'+#$P,S4T,2P@(#,X+C,L(" W-2XU+# P,# P
M,C<P,"PP,# P,#(V.# L,#<P,S X+# V-#DL+ T*,# P-C U."PP,# P,# P
M,# Q+# P,# Q,#<P-C0L,# P-S<S,S0L,# P-30P,#$Y,BQ72$],+%=(3TQ%
M4T%,12!&545,4RQ'3D<P.#(L54Q44D$@3%,@0T%20B!$645$($133" Q-2!0
M4$TL1RPQ,#,U-#0L(" S."XS+" @-S<N,"PP,# P,#,P,# L,# P,# R.3<V
M+# W,#,P."PP-S Y+"P-"C P,#8P-3@L,# P,# P,# P,2PP,# P,3 W,#8T
M+# P,#<W,S,T+# P,#4T,# Q.3(L5TA/3"Q72$],15-!3$4@1E5%3%,L1TY'
M,#@R+%5,5%)!($Q3($-!4D(@1%E%1"!$4TP@,34@4%!-+$<L,3 S-30T+" @
M,S@N,RP@(#<T+C(L,# P,# P.3 P+# P,# P,#@Y-"PP-S S,#@L,#<P.2PL
M#0HP,# V,#4X+# P,# P,# P,#$L,# P,#$P-S V-"PP,# W-S,S-"PP,# U
M-# P,3DR+%=(3TPL5TA/3$5304Q%($9514Q3+$=.1S X,RQ53%1202!,4R!#
M05)"($133" Q-2!04$TL1RPQ,#,U-#0L(" S."XS+" @-S8N,RPP,# P,#$Y
M,# L,# P,# Q.#@V+# W,#,P."PP-S Y+"P-"C P,#8P-3@L,# P,# P,# P
M,2PP,# P,3 W,#8X+# P,#<W,S,T+# P,#4T,# Q.3(L5TA/3"Q72$],15-!
M3$4@1E5%3%,L1TY2,#(W+%)53#@W($-!4D(@151/2" U+C<L1RPQ,#,U-#0L
M(" V,2XT+" @-C,N."PP,# P,# T,# L,# P,# P,SDY+# W,#,P."PP-S$Y
M+"P-"C P,#8P-3@L,# P,# P,# P,2PP,# P,3 W,#<P+# P,#<W,S,T+# P
M,#4T,# Q.3(L5TA/3"Q72$],15-!3$4@1E5%3%,L1TY2,#(W+%)53#@W($-!
M4D(@151/2" U+C<L1RPQ,#,U-#0L(" U.2XV+" @-C0N-2PP,# P,#$W,# L
M,# P,# Q-CDU+# W,#,P."PP-S(X+"P-"C P,#8P-3@L,# P,# P,# P,2PP
M,# P,3 W,3(U+# P,#4U,30Q+# P,#4T,# Q.3(L5TA/3"Q72$],15-!3$4@
M1E5%3%,L1TY',#@R+%5,5%)!($Q3($-!4D(@1%E%1"!$4TP@,34@4%!-+$<L
M,3 S-3,R+" @,S@N,RP@(#<V+C,L,# P,# T,# P+# P,# P,SDW,"PP-S S
M,#@L,3 P-BPL#0HP,# V,#4X+# P,# P,# P,#$L,# P,#$P-S$R-2PP,# U
M-3$T,2PP,# U-# P,3DR+%=(3TPL5TA/3$5304Q%($9514Q3+$=.1S X,BQ5
M3%1202!,4R!#05)"($19140@1%-,(#$U(%!032Q'+#$P,S4S,BP@(#,X+C,L
M(" W-BXW+# P,# P,S4P,"PP,# P,#,T-S(L,#<P,S X+#$P,#8L+ T*,# P
M-C U."PP,# P,# P,# Q+# P,# Q,#<Q,C8L,# P-34Q-3<L,# P-30P,#$Y
M,BQ"5$M2+#)"(%1254-+24Y'+$=.1S X,RQ53%1202!,4R!#05)"($133" Q
M-2!04$TL1RPQ,#,U,S$L(" S."XS+" @-S0N-2PP,# P,#0S,# L,# P,# T
M,C<P+# W,#,P."PQ,#$V+"P-"C P,#8P-3@L,# P,# P,# P,2PP,# P,3 W
M,3(V+# P,#4U,34W+# P,#4T,# Q.3(L0E1+4BPR0B!44E5#2TE.1RQ'3D<P
M.#,L54Q44D$@3%,@0T%20B!$4TP@,34@4%!-+$<L,3 S-3,Q+" @,S@N,RP@
M(#<T+C0L,# P,# S,C P+# P,# P,S$W."PP-S S,#@L,3 Q-BPL#0HP,# V
M,#4X+# P,# P,# P,#$L,# P,#$P-S$U,"PP,# U-3$U-RPP,# U-# P,3DR
M+$)42U(L,D(@5%)50TM)3D<L1TY',#@R+%5,5%)!($Q3($-!4D(@1%E%1"!$
M4TP@,34@4%!-+$<L,3 S-3,P+" @,S@N,RP@(#<V+C<L,# P,# S-C P+# P
M,# P,S4W,BPP-S S,#@L,3$U.2PL#0HP,# V,#4X+# P,# P,# P,#$L,# P
M,#$P-S$U,"PP,# U-3$U-RPP,# U-# P,3DR+$)42U(L,D(@5%)50TM)3D<L
M1TY',#@R+%5,5%)!($Q3($-!4D(@1%E%1"!$4TP@,34@4%!-+$<L,3 S-3,P
M+" @,S@N,RP@(#<V+CDL,# P,# S.3 P+# P,# P,S@V."PP-S S,#@L,3$U
M.2PL#0HP,# V,#4X+# P,# P,# P,#$L,# P,#$P-S$V-BPP,# Y.#4W.2PP
M,# U-# P,3DR+%=(3TPL5TA/3$5304Q%($9514Q3+$=.1S X,RQ53%1202!,
M4R!#05)"($133" Q-2!04$TL1RPQ,#,U-C$L(" S."XS+" @-S<N.2PP,# P
M,#0T,# L,# P,# T,S8R+# W,#,P."PQ,S X+"P-"C P,#8P-3@L,# P,# P
M,# P,2PP,# P,3 W,38V+# P,#DX-3<Y+# P,#4T,# Q.3(L5TA/3"Q72$],
M15-!3$4@1E5%3%,L1TY',#@S+%5,5%)!($Q3($-!4D(@1%-,(#$U(%!032Q'
M+#$P,S4V,2P@(#,X+C,L(" W-BXQ+# P,# P,S$R-2PP,# P,#,Q,#$L,#<P
M,S X+#$S,#@L+ T*,# P-C U."PP,# P,# P,# Q+# P,# Q,#<Q-S4L,# P
M,# S.#,L,# P-30P,#$Y,BQ"5$M2+#)"(%1254-+24Y'+$=.1S X,RQ53%12
M02!,4R!#05)"($133" Q-2!04$TL1RPQ,#,U-#@L(" S."XS+" @-S@N-"PP
M,# P,#<U,# L,# P,# W-#,T+# W,#,P."PQ,S0R+"P-"C P,#8P-3@L,# P
M,# P,# P,2PP,# P,3 W,3DT+# P,#4U,34W+# P,#4T,# Q.3(L0E1+4BPR
M0B!44E5#2TE.1RQ'3D<P.#,L54Q44D$@3%,@0T%20B!$4TP@,34@4%!-+$<L
M,3 S-30Y+" @,S@N,RP@(#<X+C L,# P,# T,C P+# P,# P-#$V-"PP-S S
M,#@L,30U,2PL#0HP,# V,#4X+# P,# P,# P,#$L,# P,#$P-S$Y-"PP,# U
M-3$U-RPP,# U-# P,3DR+$)42U(L,D(@5%)50TM)3D<L1TY',#@S+%5,5%)!
M($Q3($-!4D(@1%-,(#$U(%!032Q'+#$P,S4T.2P@(#,X+C,L(" W-RXW+# P
M,# P,S(P,"PP,# P,#,Q-S,L,#<P,S X+#$T-3$L+ T*,# P-C U."PP,# P
M,# P,# Q+# P,# Q,#<R,C4L,# P,# Q-S,L,# P-30P,#$Y,BQ72$],+%=(
M3TQ%4T%,12!&545,4RQ'3E(P,C<L4E5,.#<@0T%20B!%5$]((#4N-RQ'+#$P
M,S4S,RP@(#4Y+C8L(" V.2XP+# P,# P-C P,"PP,# P,#4Y-C0L,#<P,S X
M+#$W-34L+ T*,# P-C U."PP,# P,# P,# Q+# P,# Q,#<R,C8L,# P,# Q
M-S,L,# P-30P,#$Y,BQ72$],+%=(3TQ%4T%,12!&545,4RQ'3E(P,C<L4E5,
M.#<@0T%20B!%5$]((#4N-RQ'+#$P,S4S,RP@(#4Y+C8L(" V."XX+# P,# P
M,C P,"PP,# P,#$Y.#@L,#<P,S X+#$X,#,L+ T*,# P-C U."PP,# P,# P
M,# Q+# P,# Q,#<R-#4L,# P.3@xxxxx,# P-30P,#$Y,BQ72$],+%=(3TQ%
M4T%,12!&545,4RQ'3E$P,S4L4%5,.3$@0T%20B!%5$]((#4N-RQ'+#8X,3DT
M+" @-3DN,"P@(#8S+C@L,# P,# R,# P+# P,# P,3DY-2PP-S S,#@L,3DU
M-RPL#0HP,# V,#4X+# P,# P,# P,#$L,# P,#$P-S(T-2PP,# Y.#4Y-2PP
M,# U-# P,3DR+%=(3TPL5TA/3$5304Q%($9514Q3+$=.4C R-RQ254PX-R!#
M05)"($543T@@-2XW+$<L-C@xxxxx(" U.2XV+" @-C8N."PP,# P,#,P,# L
M,# P,# R.3@V+# W,#,P."PQ.34W+"P-"C P,#8P-3@L,# P,# P,# P,2PP
M,# P,3 W,C4W+# P,#4U,C,U+# P,#4T,# Q.3(L5TA/3"Q72$],15-!3$4@
M1E5%3%,L1TY2,#(W+%)53#@W($-!4D(@151/2" U+C<L1RPV.#$Y,RP@(#4Y
M+C8L(" V-RXQ+# P,# P-# P,"PP,# P,#,Y.#$L,#<P,S X+#(Q,C4L+ T*
M,# P-C U."PP,# P,# P,# Q+# P,# Q,#<R-3<L,# P-34R,S4L,# P-30P
M,#$Y,BQ72$],+%=(3TQ%4T%,12!&545,4RQ'3D<P.#,L54Q44D$@3%,@0T%2
M0B!$4TP@,34@4%!-+$<L-C@xxx,L(" S."XS+" @-S0N,RPP,# P,#$W,# L
M,# P,# Q-C@Y+# W,#,P."PR,3(U+"P-"C P,#8P-3@L,# P,# P,# P,2PP
M,# P,3 W,C4W+# P,#4U,C,U+# P,#4T,# Q.3(L5TA/3"Q72$],15-!3$4@
M1E5%3%,L1TY2,#(W+%)53#@W($-!4D(@151/2" U+C<L1RPV.#$Y,RP@(#4Y
M+C8L(" V-BXQ+# P,# P,C8P,"PP,# P,#(U.#DL,#<P,S X+#(Q,C4L+ T*
M,# P-C U."PP,# P,# P,# Q+# P,# Q,#<R-3DL,# P.3@xxxxx,# P-30P
M,#$Y,BQ72$],+%=(3TQ%4T%,12!&545,4RQ'3D<P.#,L54Q44D$@3%,@0T%2
M0B!$4TP@,34@4%!-+$<L-C@Q.#@L(" S."XS+" @-S<N."PP,# P,#,P,# L
M,# P,# R.3<U+# W,#,P."PR,3,U+"P-"C P,#8P-3@L,# P,# P,# P,2PP
M,# P,3 W,C4Y+# P,#DX-3DU+# P,#4T,# Q.3(L5TA/3"Q72$],15-!3$4@
M1E5%3%,L1TY2,#(W+%)53#@W($-!4D(@151/2" U+C<L1RPV.#$X."P@(#4Y
M+C8L(" V-BXU+# P,# P,C P,"PP,# P,#$Y.3(L,#<P,S X+#(Q,S4L+ T*
M,# P-C U."PP,# P,# P,# Q+# P,# Q,#<R-3DL,# P.3@xxxxx,# P-30P
M,#$Y,BQ72$],+%=(3TQ%4T%,12!&545,4RQ'3E(P,C<L4E5,.#<@0T%20B!%
M5$]((#4N-RQ'+#8X,3@X+" @-3DN-BP@(#8W+C(L,# P,# T,# P+# P,# P
M,SDX,2PP-S S,#@L,C$S-2PL#0HP,# V,#4X+# P,# P,# P,#$L,# P,#$P
M-S(V.2PP,# U-3(S-2PP,# U-# P,3DR+%=(3TPL5TA/3$5304Q%($9514Q3
M+$=.1S X,RQ53%1202!,4R!#05)"($133" Q-2!04$TL1RPV.#$Y,BP@(#,X
M+C,L(" W."XP+# P,# P-# P,"PP,# P,#,Y-C8L,#<P,S X+#(R-#0L+ T*
M,# P-C U."PP,# P,# P,# Q+# P,# Q,#<R-CDL,# P-34R,S4L,# P-30P
M,#$Y,BQ72$],+%=(3TQ%4T%,12!&545,4RQ'3E(P,C<L4E5,.#<@0T%20B!%
M5$]((#4N-RQ'+#8X,3DR+" @-3DN-BP@(#8V+C8L,# P,# S,# P+# P,# P
M,CDX-BPP-S S,#@L,C(T-"PL#0HP,# V,#4X+# P,# P,# P,#$L,# P,#$P
M-S(V.2PP,# U-3(S-2PP,# U-# P,3DR+%=(3TPL5TA/3$5304Q%($9514Q3
M+$=.43 S-2Q054PY,2!#05)"($543T@@-2XW+$<L-C@xxx(L(" U.2XP+" @
M-C N,2PP,# P,#$T,# L,# P,# Q-# P+# W,#,P."PR,C0T+"P-"C P,#8P
M-3@L,# P,# P,# P,2PP,# P,3 W,C<P+# P,# P,3<S+# P,#4T,# Q.3(L
M5TA/3"Q72$],15-!3$4@1E5%3%,L1TY',#@S+%5,5%)!($Q3($-!4D(@1%-,
M(#$U(%!032Q'+#$P,S4V,RP@(#,X+C,L(" W."XR+# P,# P-S4P,"PP,# P
M,#<T,S4L,#<P,S X+#(R-#4L+ T*,# P-C U."PP,# P,# P,# Q+# P,# Q
M,#<R-S@L,# P.3@xxxxx,# P-30P,#$Y,BQ72$],+%=(3TQ%4T%,12!&545,
M4RQ'3E$P,S4L4%5,.3$@0T%20B!%5$]((#4N-RQ'+#8X,C Q+" @-3DN,"P@
M(#8P+C(L,# P,# R,# P+# P,# P,C P,"PP-S S,#@L,C,T,BPL#0HP,# V
M,#4X+# P,# P,# P,#$L,# P,#$P-S(W."PP,# Y.#4Y-2PP,# U-# P,3DR
M+%=(3TPL5TA/3$5304Q%($9514Q3+$=.4C R-RQ254PX-R!#05)"($543T@@
M-2XW+$<L-C@R,#$L(" U.2XV+" @-C4N,BPP,# P,#,P,# L,# P,# R.3@Y
M+# W,#,P."PR,S0R+"P-"C P,#8P-3@L,# P,# P,# P,2PP,# P,3 W,C<X
M+# P,#DX-3DU+# P,#4T,# Q.3(L5TA/3"Q72$],15-!3$4@1E5%3%,L1TY2
M,#(W+%)53#@W($-!4D(@151/2" U+C<L1RPV.#(P,2P@(#4Y+C8L(" V-2XW
D+# P,# P-# P,"PP,# P,#,Y.#4L,#<P,S X+#(S-#(L+ T*
`
end
.
- Follow-Ups:
- Re: Problem with CSV Date column
- From: VJ
- Re: Problem with CSV Date column
- References:
- Problem with CSV Date column
- From: Bill Nguyen
- Re: Problem with CSV Date column
- From: Bill Nguyen
- Re: Problem with CSV Date column
- From: VJ
- Problem with CSV Date column
- Prev by Date: Re: Report By Year
- Next by Date: Re: Is VB Caca??
- Previous by thread: Re: Problem with CSV Date column
- Next by thread: Re: Problem with CSV Date column
- Index(es):