i have issue i'm importing data excel spreadsheet access 2016. have several fields contain either mix of text , number records , mix of date format , blank records. i've read, access scan number of rows (8?) determine data type. if manually change column date format short date in excel, when import access changes data type text if first rows not in date format. there way change how many rows access scans before determining field's data type? it's frustrating have sort multiple columns in excel have import several files per day...
access changes data type text if first rows not in date format
of course. date field can hold valid date value or null.
so link data , use isdate filter values can read text. convert these in second query updates table.
Comments
Post a Comment