Can I turn off the error generated tables

[AccessHar]

Whne I am importing Records to a Table, if the import does not work error
table are generated, can I turn off the generation of these error messages.
If so how can I do that..

 

[Jeff Boyce]

So you don't care to know if all the records actually made it into your
Access table?

If knowing about the errors isn't important in your situation, why not just
delete the error table after the import?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[AccessHar]

i am aware that I can delet the error tables manually, but the utility is
generic and the users don't know how to operate access, I would rather keep
them away from the view of the tables.

The one field that it does not import is not important to the data they are
looking for from the inported CSV files.

Actually the real problem that I can get solved is where I use the syntax
"DoCmd.TransferText acImportDelim, , _
"TBL_All_CSV_RECORDS", Path & NewName, False"

the Table "TBL_ALL_CSV_RECORDS" is automatically generated, but some cells
of the same columns containg Text and numbers, it has problem importing both,
what can I do to import numbers to a Fiedl and Text to a field.........

 

[Jeff Boyce]

If there is a data conversion problem, another approach might be to import
to a generic (?all text-type) table, then use queries to parse the data into
the more permanent (and correctly-typed) tables in Access.

Besides, raw CSV (or Excel) data may not be well normalized. The above
process lets you take such input data and convert it to a structure that
Access has the tools to handle.


Regards

Jeff Boyce
Microsoft Office/Access MVP