Memo to Text or Number

[tennisbuck]

Hello,



I have a table in access around 5 milltion records where I need to convert on field from memo to text or a number. This isn't a large feild only 6 numbers so size won't be a problem. Does anybody have any suggestions in how to perform this operation?

Thanks,

Mike

[offie]

Like this?
http://office.microsoft.com/en-us/ac...001229018.aspx

[Missinglinq]

...I need to convert on field from memo to text or a number...

First off, you really need to get it straight, in your own mind, which it is you're trying to do, change this Field to a Number or to Text! Are these 'numbers' going to be used to do math? Are they 'serial numbers?' What?

...This isn't a large feild only 6 numbers...

Are you talking about 6 digits, here, or 6 sets of digits?

We really need more information, in order to help you.

Linq ;0)>