Excel to Access 2010 Data Import Errors (1 Viewer)

[ALewis06]

I have tried many ways that I found on the web to solve this issue: when I import my Excel 2010 spreadsheet to Access 2010, the date field is coming back with type conversion failure on the date field. The spreadsheet has 59,000 rows. How can I quickly resolve this problem? I have tried changing the Excel file to a csv file and it comes back with even more errors. Suggestions?

 

[boblarson]

There are likely invalid dates in the field. Can you sort the Excel file both ascending and descending on that field to see what's there? Also, is it really formatted as a date field and if so what is the format?

 

[ALewis06]

You're right. These dates were entered manually by many different indivuduals so when I filtered on the date field, some only put 2012, 2011 etc. while others put an actual date like 3/31/2013, then others put N/A, n/a. The cell format is *m/dd/yyyy. Guess I have some clean-up to do.