<div>
Another thought here.. most established developers will import Excel data into Access into a 'temporary' table with all text fields. &nbsp;(I usually prefix these with timp_)<br />
That way, all data makes it into Access without any data conversion errors. <br />
<br />
Then, you can run a bunch of SELECT / UPDATE queries to 'scrub' your data, making sure dates are dates, numbers are numbers, etc. <br />
Then when you're satisfied your data is good, INSERT into your ultimate destination table(s), then delete all from the temp table.<br />
<br />
Hope this helps.<br />
-Jim
</div>


Another thought here.. most established developers will import Excel data into Access into a 'temporary' table with all text fields.  (I usually prefix these with timp_)
That way, all data makes it into Access without any data conversion errors.

Then, you can run a bunch of SELECT / UPDATE queries to 'scrub' your data, making sure dates are dates, numbers are numbers, etc.
Then when you're satisfied your data is good, INSERT into your ultimate destination table(s), then delete all from the temp table.

Hope this helps.
-Jim

<div>
<div class="content wysiwyg-content">
I have imported an excel file into access. &nbsp;One field is being read as numeric if the user entered only numbers into that column, but in fact in the Access application it is a text field. &nbsp;When I try to join the imported table field (imported as &quot;number&quot;) to the related field (&quot;Text&quot;) it of course does not work. &nbsp;How can I programatically change the field type from number to text after I import the table and before I need to join it to related tables? &nbsp;Thank you!
</div>
</div>


I have imported an excel file into access.  One field is being read as numeric if the user entered only numbers into that column, but in fact in the Access application it is a text field.  When I try to join the imported table field (imported as "number") to the related field ("Text") it of course does not work.  How can I programatically change the field type from number to text after I import the table and before I need to join it to related tables?  Thank you!

Change Access field type from number to text in VBA.

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.