Mega Code Archive

 

Categories / Delphi / ADO Database

 

Batchmove from text doesnt create time or timestamp fields

Question: How when I use MatchMode BatCopy of BatchMove and the source is a text file with time or timestamp data I always get Alpha data in the destination table? Answer: The text driver doesn't support time or timestamp data types. You must alter the table once batchmove is complete and change the field type yourself.