date type conversion in acces
-
Hello Guys,
I have mssql 2008 database with DATE as datatype column. I have made an ODBC pointed to mssql 2008(not using sql native client) and a linkedtable in access 2003 (linked is in fact to a view)
Strange the date coming from mssql appear now in access as TEXT.
How could avoid this and see the date in access as DATE.
thanks in advance,
Hadrian
-
Change the field type on Access table.
If you have both fields set to date type, try to use cast conversion while sending the info to
the fields.
For further help you can write me: marcosfac@gmail.com
Best Regards,
Marcos Rosa / marcosfac@gmail.com
-
Hello,
I cannot change the date type in access,because it(access) dont allow me. I was thinking about date type supported by access.
Best Regards,
Hadrian
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply