Solving problems importing data into MS Access
Most of my business time is spent with Oracle, SQL Server and Cache databases, but for minor ETL tasks too big for Excel and too small for Informatica, I often break out Microsoft Access. When importing data into Access, I sometimes get its dreaded Import Errors or experience other problems. I commonly run into these kinds of issues when importing one of our hospital’s charge master files because charge codes often contain alpha characters and asterisks mixed in with numbers.