Use SQL DDL to Append a temp field, copy data, Delete & Add the old field with the new type ie .. ALTER TABLE a_table ADD tempfield STRING INSERT INTO tempfield SELECT thefield ALTER TABLE a_table DROP thefield ALTER TABLE a_table ADD thefield INTEGER copy data back.. ALTER TABLE DROP tempfield Grant Black Software Developer SmartMove (NZ) Ltd Phone: +64 9 361-0219 extn 719 Fax : +64 9 361-0211 Email: [EMAIL PROTECTED] > -----Original Message----- > From: Chris Crowe [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 18, 1999 11:25 AM > To: Multiple recipients of list Delphi > Subject: [DUG]: Changing a field type in an Access Database > > > I am wanting to change the field type of a field in an Access > Database, it > has data and anywhere up to 1500 records in the table. > > I want to change the data type of the field from a Text to a > Long Integer. > > Does anyone know how? > > Chris Crowe > [EMAIL PROTECTED] > Want a free tool to help search the Microsoft BB and Search > pages?, goto > http://www.adrock.com/msarticle > > -------------------------------------------------------------- > ------------- > New Zealand Delphi Users group - Delphi List - > [EMAIL PROTECTED] > Website: http://www.delphi.org.nz > --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
