changing data types

[bromer]

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

Any help is appreciated!

[kishore]

Which Database are you using?

[bromer]

sorry about that - Access 97

[kishore]

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