<div>
Hi deer7777,<br />
<br />
A bit more info?<br />
Import from where? Linked?<br />
<br />
Gary
</div>


Hi deer7777,

A bit more info?
Import from where? Linked?

Gary

<div>
I am importing and Excel spreadsheet from my desktop but I need to change a field type from text to number. &nbsp;I want to do that with a query. &nbsp;I do not have the table linked. &nbsp;I will only be importing it into my database.
</div>


I am importing and Excel spreadsheet from my desktop but I need to change a field type from text to number.  I want to do that with a query.  I do not have the table linked.  I will only be importing it into my database.

<div>
&lt;I want to do that with a query.&gt; what query ? pls explain<br />
<br />
How are you importing the Excel file?
</div>


<I want to do that with a query.> what query ? pls explain

How are you importing the Excel file?

<div>
You can save this as a query in access<br />
<br />
ALTER TABLE MyTable ALTER COLUMN Field1 Long;<br />
<br />

</div>


You can save this as a query in access

ALTER TABLE MyTable ALTER COLUMN Field1 Long;



<div>
Open a new query in design view &amp;&nbsp;change to SQL view.<br />
Replace MyTable with the name of your Table &amp;&nbsp;Field1 with the name of your field
</div>


Open a new query in design view & change to SQL view.
Replace MyTable with the name of your Table & Field1 with the name of your field

<div>
<div class="content wysiwyg-content">
Need to change the imported table's field type from text to number with a query. &nbsp;How can I do that?
</div>
</div>


Need to change the imported table's field type from text to number with a query.  How can I do that?

MS Access 2007 Query - Change field format type from text to numbeer

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.