<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=943462812-21052003><FONT face=Arial color=#0000ff size=2>One
way that I have done this in the past is:</FONT></SPAN></DIV>
<DIV><SPAN class=943462812-21052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=943462812-21052003><FONT face=Arial color=#0000ff size=2>1)
Build a table locally by adding fields up to the one that you want changed, then
add the field to the new table as you want it to be, then add the rest of the
fields.</FONT></SPAN></DIV>
<DIV><SPAN class=943462812-21052003><FONT face=Arial color=#0000ff size=2>2)
Import all of the data into the new table.</FONT></SPAN></DIV>
<DIV><SPAN class=943462812-21052003><FONT face=Arial color=#0000ff size=2>3)
Delete the original table.</FONT></SPAN></DIV>
<DIV><SPAN class=943462812-21052003><FONT face=Arial color=#0000ff size=2>4)
Export the existing table to the origal database.</FONT></SPAN></DIV>
<DIV><SPAN class=943462812-21052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=943462812-21052003><FONT face=Arial color=#0000ff
size=2>OR</FONT></SPAN></DIV>
<DIV><SPAN class=943462812-21052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=943462812-21052003><FONT face=Arial color=#0000ff size=2>If
position in the table does not matter, simply rename the existing field, append
the new field to the end, and then copy the data from the old field to the new
field. I'm not sure if you can delete the old field.</FONT></SPAN></DIV>
<DIV><SPAN class=943462812-21052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=943462812-21052003><FONT face=Arial color=#0000ff
size=2>HTH,</FONT></SPAN></DIV>
<DIV><SPAN class=943462812-21052003><FONT face=Arial color=#0000ff
size=2>Bobby</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Ervin
Brindza<BR><B>Sent:</B> Wednesday, May 21, 2003 1:57 AM<BR><B>To:</B>
AccessD@databaseadvisors.com<BR><B>Subject:</B> [AccessD] Change datatype
through VBA<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>
<DIV><FONT face=Arial size=2>How to change the datatype from Text to
Numeric(Integer) in an external database?</FONT></DIV>
<DIV><FONT face=Arial size=2>TIA,</FONT></DIV>
<DIV><FONT face=Arial size=2>
Ervin</FONT></DIV></FONT></DIV></BLOCKQUOTE></BODY></HTML>