Importing data from Excel

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

Tony Williams

I'm trying to import data from an Excel spreadsheet. Some of the columns are
dates and times. The cells are formatted as such but when I go through the
import wizard these values are numbers with decimals (in the case of times)
The wizard recognises the field as Date/Time field so why aren't they shown
as such? Also the import doesn't work as I'm getting an error message right
at the end of the process. Is this something to do with the Date/Time
fields?
Thanks
Tony
 
I'm trying to import data from an Excel spreadsheet. Some of the columns are
dates and times. The cells are formatted as such but when I go through the
import wizard these values are numbers with decimals (in the case of times)
The wizard recognises the field as Date/Time field so why aren't they shown
as such? Also the import doesn't work as I'm getting an error message right
at the end of the process. Is this something to do with the Date/Time
fields?
Thanks
Tony
Click to expand...

After you complete the import to a table in Access just go to design
view of the table and change the format of the fields that you are
talking about.

-Good luck
 
Back
Top