No delimitations

[brncao]

I'm trying to import a csv file into a database. However, Date does not have any delimitations. It looks like 06042015 (that's 06/04/2015). Any workaround?

 

[Ron Coderre]

If you're using Data.From_Text...
• Check: Delimited.......Click: Next
• Check: Comma..........Click: Next
• Select your "date" column...Check: Date MDY
...Click: Finish

Does that help?

 

[Micron]

If it will always be that length, you could use the Len function to get the first two and append "/". Then get the second pair with the Mid function and append "/", and lastly the Right function to get the last part. Then concatenate the 3 parts. If you need to worry about the data type, use CDate to convert the value to a date.