Change table date/time field to text field in code



How can I programatically, take some Date/Time fields present in a table in
the current database and change their type to text?

dixie


.



Relevant Pages

  • Append records into another database
    ... I know how to append records from one table to another in the same database, ... Prev by Date: ...
    (comp.databases.ms-access)
  • Re: How I dramatically sped up DB file updating
    ... > Yet, if it takes 28 seconds to update 500 records on a Access database, ... > I do not remember to have found noticeable speed differences when batch ... This approach isn't great...it doesn't give consistent times. ... Prev by Date: ...
    (comp.lang.pascal.delphi.misc)
  • curious about command buttons
    ... This of course isn't a life or death situation for my database, ... Stuart K. ... Prev by Date: ...
    (comp.databases.ms-access)
  • Re: Getting Date Only
    ... > formatting to mm/dd/yyyy. ... > This is the same code I used in another database using Nowinstead with ... Prev by Date: ...
    (microsoft.public.access.formscoding)
  • creating tables at runtime
    ... of the prev table. ... i have table called MSP_Number_Fields in Microsoft Project ... Server2003 database ...
    (microsoft.public.sqlserver.programming)