Search results

I discovered that the ACCESS default date format is MM/DD/YY. In order to get around this I will have to build an import record layout for each of my downloads, that's over 800 fields in 12 tables. I was hoping to avoid the work. ---------------- Thanks for the code snippet, Anton

This is a test of a biweekly massive data transfer from an Oracle Business Intelligence database with which I do not have ODBC connectivity. ------------ Anton

I upgraded to Access-2010 and the Text File Import function will not recognize dates in the format YYYY-MM-DD. The import dialogue sees enough to recognize the field as a date, but then every date encountered is written to the Import-Errors table. This is true whether the file has a .txt or...

I have been using ACCESS since version 2000. I have always been able to figure out solutions to my development problems, until I encountered a corporate phased-conversion from OFFICE-2003 to OFFICE-2007. I have encountered problems that I could not find solutions to, except on the forum, so I...