Import problem - Date field

B

Berkshire

I'm fairly new to Access. Have a spreadsheet I am trying to copy / import
that has a date field. This date field is in a Month-Year format, i.e.
Apr-06. I have entered the data in Excel as 4/1/06. I have months that go
back to 2003. However, after importing, all of the months show as 2006.

Any ideas would be greatly appreciated.
 
P

Peter Taylor

Hi,

If you click on Advanced in the import wizard, what is the data type for the
column that your having problems with. Try changing it to DATE if its not
already selected, or opt for TEXT, import and check if the data has come in
ok and then change the data type back to DATE once it's imported.


Sulphy.
 

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

Simple but profound 7
Combine a text and number field to create a date 2
Date field format 3
Date Calculation - Astro Calculation 2
Date format change 4
ACCESS IMPORT DATE/TIME IN CSV FILE 2
Excel Import Comments 3
import dates from excel spreadsheet (problem?) 1

Top