changing data types

using VB, how can you convert an existing table field data type from text to long integer?

Any help is appreciated!

Which Database are you using?

sorry about that - Access 97

you cannot directly change data type of table in access or Sql Server 6.5 but

You can create a duplicate table at runtime and drop the field you want to edit and add field.

Note:
To add and drop a field See Alter table in Access Help.

And then you can use select statement to pull all the data and place in the duplicate table.

I hope this helps