Question Import from Excel to Access

[tcbs]

Hi. I am a new Access user. I am trying to import data from Excel 2007 to Access 2007. Several of the Excel columns contain dates (all formatted the same, eg *3/8/2011). When I import the Excel data into Access some of the columns that should have dates now contain numbers, yet other columns with dates import the dates. How do I stop the dates from changing into numbers?

Thanks!

 

[ghudson]

Ensure all date fields in your table are already formatted as a date field or use an import specification to specify the imported fields data type.

 

[tcbs]

Thank you g.

 

[asad.saeed]

if you have huge data than pls tell me I can give you idea to convert it into date format