<div>
When you import the file, what data type are you using for the column that contains the date &amp;&nbsp;text fields?
</div>


When you import the file, what data type are you using for the column that contains the date & text fields?

<div>
That should have read: 'a problem similar to the one you are experiencing..' &nbsp;:o)
</div>


That should have read: 'a problem similar to the one you are experiencing..'  :o)

<div>
I cannot put dummy data into the file as it will need to retain the date information.
</div>


I cannot put dummy data into the file as it will need to retain the date information.

<div>
The import works to not get the error
</div>


<div>
<div class="content wysiwyg-content">
I am imporing an excel file where one column has dates and text. &nbsp;When I link it to MSAccess 2003 the text shows fine but the date shows a #Num! error. &nbsp;Is there a way to fix this???
</div>
</div>


I am imporing an excel file where one column has dates and text.  When I link it to MSAccess 2003 the text shows fine but the date shows a #Num! error.  Is there a way to fix this???

Excel #Num! error in MSAccess linking table

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.

Microsoft Access

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.