MarkSnark1
asked on
Convert Text field yyyymmdd in Access to Date format mm/dd/yyyy
I am importing about 3000 records from an Excel file into an Access table which will eventually end up in a sql table. There are two columns (Text) in the Excel file that have a date recorded as yyyymmdd (example 20091031 for Oct. 10th 2009). In the end I would like to have the field in Access be a date type and show up as 10/31/2009.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I object to this closure - both solutions will work.
My comments were posted with no knowledge of what had been tried outside of this thread, but they are tested - and will format the data as described in the original post.
My comments were posted with no knowledge of what had been tried outside of this thread, but they are tested - and will format the data as described in the original post.
ASKER
I did not try the first solution so I do not know but I am certainly not adverse to awarding the points to Mbizup. I was just uncertain how to go about this.
These are going out as "neglected questions" when solutions have already been accepted.
ASKER
Sorry about the confusion and thank you to MbiZup for his work and help.
ASKER
Accepted answer: 0 points for MarkSnark1's comment #37778561
for the following reason:
I found the solution in Excel and then imported into access.