I have the output of a SQL Server 2008 query saved to a text file and I am trying to link it to an Access database (Access 2007-2010).
The text file contains two date columns in the SQL Server 2008
datetime format, like this:
EFFECTIVE START DATE: --------------------- 2013-07-01 00:00:00.000 EFFECTIVE END DATE: ------------------- 2014-06-30 00:00:00.000
In the Import wizard, I click Advanced and change the following:
- Code Page = Western European (Window) instead of Unicode (UTF-8)
For the 2
- data type = Date/Time
- date order = YMT
- Date delimiter = –
- Leading zeros in dates = ticked
While still in the import wizard the data looks fine but as soon as the import is finished and I open the table in Access, I see #Num! in the two date columns.
I have tried a combination of settings in the import wizard (leave the code page as Unicode, not change the date order, not ticking the leading zeros in dates, etc) but in the end I had to import the dates as text, which stops me from doing any calculations now.
Many thanks in advance for the help