ndornack
asked on
Access Import .csv file Time Value error
I am using Access2003 and trying to import the following two .csv files. I am consistently getting the error about not being able to convert the fields in:
punches.csv
Punch Time
punchestransferred.csv
Actual Start
Actual End
AdjustedStart
AdjustedEnd
I have even tried linking to the .csv file and even get errors doing that. These are being formatted as Date/Time upon linking or import.
I DO NOT want to store these as text values in the database. How can I get these to convert?
punches.csv
punchestransferred.csv
punches.csv
Punch Time
punchestransferred.csv
Actual Start
Actual End
AdjustedStart
AdjustedEnd
I have even tried linking to the .csv file and even get errors doing that. These are being formatted as Date/Time upon linking or import.
I DO NOT want to store these as text values in the database. How can I get these to convert?
punches.csv
punchestransferred.csv
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.