Date field in csv file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a csv file which I am trying to import into Access. I am able to make
a table with import wizard but only with errors. It says it encountered some
problems and generates an error table. These errors are associated with 3
date fields that I have in csv file. I have copied here these fields from one
record from my csv file here:
"8345190011344500","1000003250511039",5/28/2005 12:00 AM,6/6/2005 12:00
AM,6/6/2005 12:00 AM,"SF","2J","R","2J"
The Access table that gets generated has blank values in the date field. I
need these values. How can I do it
 
I tested the record you posted and the dates are legitimate dates and should
not cause a problem importing. There are two things to check. Look at the
format of the date fields in your table. They should be General Date. The
other thing is to look at the data in the csv file and see if there are any
date fields that have no value. This could cause the problem.
 
Back
Top