<div>
auuughhh.... sounds like hard work huh? but i guess it will have to be done somehow.<br />
<br />
i am working on an alternative way of solving this problem, maybe importing line by line and fish out the bad records. i am investigating on the speed of this approach.<br />
<br />
i like ur idea of clening out the redundant tables. i am sure it will be useful. <br />
<br />
Keith<br />
<br />

</div>


auuughhh.... sounds like hard work huh? but i guess it will have to be done somehow.

i am working on an alternative way of solving this problem, maybe importing line by line and fish out the bad records. i am investigating on the speed of this approach.

i like ur idea of clening out the redundant tables. i am sure it will be useful.

Keith



<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
i have a text file that i need to import to an existing table. i have created the import specifications and everything works fine. however, sometimes the text file has a corrupted record and the docmd.TransferText reports an error. in particular, i got error 3349 - numeric field overflow.<br />
<br />
i just need to know if there is a way to extract the bad record and stilll complete the rest of the import process?<br />
<br />
Keith
</div>
</div>


Hi

i have a text file that i need to import to an existing table. i have created the import specifications and everything works fine. however, sometimes the text file has a corrupted record and the docmd.TransferText reports an error. in particular, i got error 3349 - numeric field overflow.

i just need to know if there is a way to extract the bad record and stilll complete the rest of the import process?

Keith

Docmd.TransferText command

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.