View Single Post
Old 06-15-2018, 06:32 AM   #12
rgwfly
Newly Registered User
 
Join Date: Jun 2016
Location: Tampa Bay Area
Posts: 44
Thanks: 20
Thanked 2 Times in 2 Posts
rgwfly is on a distinguished road
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.
rgwfly is offline   Reply With Quote