<div>
flyguy80,To avoid the errors, you should load first into a &quot;staging&quot; table in which all of the columns use the text data type. &nbsp;You can then use queries and/or code to perform your data clean up and move the validated data to your permanent table(s).Patrick
</div>


flyguy80,To avoid the errors, you should load first into a "staging" table in which all of the columns use the text data type.  You can then use queries and/or code to perform your data clean up and move the validated data to your permanent table(s).Patrick

<div>
Wouldn't/couldn't the error table actually help you?<br />
<br />
Either with cleaning things up or identifying if there is a problem with the import.
</div>


Wouldn't/couldn't the error table actually help you?

Either with cleaning things up or identifying if there is a problem with the import.

<div>
<div class="content wysiwyg-content">
I wrote code in VBA to import an excel spreadsheet into Access. Now because it's formatted in a weird way in excel, i'll have to clean the imported table. I get a table with the errors of the imported data. Is there a way to eliminate the error table from being created? I have no use for it<br />
<br />
' IMPORT UNUM EXCEL SPREADSHEET AND NAME IT tblUNUMIntermittentLeaveSu<wbr />mmaryRepor<wbr />tTemp<br />
&nbsp; &nbsp; DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, &quot;tblUNUMIntermittentLeaveS<wbr />ummaryRepo<wbr />rtTemp&quot;, &quot;C:\Documents and Settings\T94HGEY\Desktop\e<wbr />Leave\UNUM<wbr />\Intermitt<wbr />ent_Leave_<wbr />Summary_Re<wbr />port(1).xl<wbr />s&quot;
</div>
</div>


I wrote code in VBA to import an excel spreadsheet into Access. Now because it's formatted in a weird way in excel, i'll have to clean the imported table. I get a table with the errors of the imported data. Is there a way to eliminate the error table from being created? I have no use for it

' IMPORT UNUM EXCEL SPREADSHEET AND NAME IT tblUNUMIntermittentLeaveSummaryReportTemp
    DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblUNUMIntermittentLeaveSummaryReportTemp", "C:\Documents and Settings\T94HGEY\Desktop\eLeave\UNUM\Intermittent_Leave_Summary_Report(1).xls"

Import Excel Spreadsheet into Access via VBA without Error 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.