I have a Unicode CSV file with string and date values that I need to convert to values I can store in a Base table. I only use about 6 values of a 28 variable file so I was reading one line at a time and updating individual values in a Base table depending on the values I read in. My understanding is that I needed to convert the date values to YYYY-MM-DD from MM/DD/YYYY before I can import them into a Base table - is that correct?
What is the best way to handle this kind of import of a CSV file?
Appended 6/3/17:
I have three computer-naive users of this database so I need the entire operation of opening and reading the Unicode CSV file performed by a macro. I am using SQL to update the records and Format(sDate, “YYYY-MM-DD”) does not work on a Unicode string. So, if I can automate opening the file in Calc and then importing to Base, then I think I can read through the Base table to perform the other update actions that I need. Code would be appreciated. Thanks.
Thanks.