Import from Excel, Date, Text to Date

[2wistd]

Hello,

I 'm trying to import a excel spreadsheet which includes a date column and some of those fields show "not attempted" ie Text. When I import them into access, i originally had them going into a text field, but I need to show the ones that are due in 60 days so I need to query using that field by date.

What is the best method to import this spreadsheet (there will actually be multiple spreadsheets with different names going into different tables) into my db and be able to see the ones that are more than 10 months old (60 days before due).

Just importing into a date field I get an error stating the 'not attempted' fields were not able to import. I have no control over the excel sheets.

 

[Cronk]

I suggest you import the spreadsheet into an Access table with every field a text field.

You can then use an append query, with the date field based on

iif(isdate(YourDateTextField), cdate(YourDateTextField),Null)