I have some date data that I export from SAP to Excel. I need to run a macro to clean up column names etc... anyway, so I'd like to convert the dates from text to actual dates at the same time.
I tried the Formatting technique. That did not work. Also...there are twenty thousand or so rows in each spreadsheet.
The dates look like dates, e.g., 8/18/2011, but when I import them into Access, they import as text.