Re: Easiest way to get Excel table into Access
If you use the wizard just be careful in your data types. I usually use text type for everything except where calculations need to be performed. More than once I had to redo it because I imported one field as text and the other as a double only to get the dreaded mismatch data type in a query.
Last edited by rgwfly; 06-15-2018 at 09:16 AM.