?dates from csv file to excel to access

J

Jerry Kinder

Help I am lost!

I imported a csv file into Excel then into Access with one column of dates.
In the csv file the dates are just numbers, I am assuming they are cereal
numbers for the dates?? How do I get them back to dates in access? I
imported first to Excel and tried to format them as dates but they remain
numbers. Then imported them to Access. In access I can not get them to
convert to dates either. LOST.

Thanks,
Jerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dates in access 3
Adding data to MS Access from csv file 0
Autonumber field in Excel that behaves the same as Access 0
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Email notifications without opening application 1
CSV files and having numbers and strings in there... 9
Cannot import CSV file into ACCESS 1
Convert a csv to xls prior to import 2

Top