excel file to access

[ponneri]

Hi All.

I have an excel file that needs to be imported into access.

I get error when importing as one column is general type in excel, but stores mostly date values ( in dd-mmm-yyyy format.) Some of the records in that column in excel have text values like "till delivery date", "upto warranty" etc... instead of dates which is a big headache.

12-jun-17
29-sep-16
till delivery
15-oct-12
13-mar-16

How do i import into access all records as text and then use the date part in queries in access as "till delivery" needs to be printed as it is; if date does not exist.

Hope I'm clear.

Any help appreciated.

 

[Gasman]

If you are doing it manually, you can save an import specification on your first import. At that time you would specify the column type to be text not date.

 

[isladogs]

Use Cstr([fieldname]) to force import as a text string

Then when running a query do something like

 if IsDate([fieldname]) Then
...
Else
..
End If

 

[ponneri]

Hi All.

Thanks for the replies.

Will try and see.

 

[ducouer]

@Ridders: thanks for your advice. I faced the same issue. This solved