Recent content by rosenpop

My computer's regional settings are mm/dd/yyyy. My .xls data is formatted as dd/mm/yyyy I believe access uses the regional settings as a default. I called our IT department last week to change this (I don't have administrator rights!) but they have advised some of the other programs I use...

Update - It did not work with one dummy row. I remember reading somewhere that Access looks at the first 14 rows to determine data type, so I just copied the same row and it worked with 14 dummy rows. My question still stands - can I reasonably assume that Access brought all of the dates in...

I like it! I'll try it. Sounds like a reasonable fix in the short term. Rosemary

I thought of that since the file originally comes to me in a .csv format, however, every time I have tried to import it into Access - using tab, comma or space delimited the data doesn't line up. Not sure why?

I have a large file with over 150 columns, 30 of which are date fields and not every cell is populated. The date format in my Excel fields are dd/mm/yyy. When I import into Access some fields are imported as date type and others as text - which I understand has to do with whether or not the...