Automating Import in Access

[jwskr]

I am attempting to automate the import of a text file in Access with a macro. There may be times when certain filed values are invalid and the import stops with a pop up box detailing the errors.

The fields in question are date/time values and may not contain data in the normal course of operation. I need to keep the field format as date/time but do not want to stop the import.

Is there a way to bypass this pop up and let the macro continue?

 

[KenReay]

Hi

I am not aware of any method to interupt the import process and all user interaction,

I would

Import into a table of all text fields

Use a query to pick out rows with problems (eg using functions such a IsDate()), and allow user to correct, then use an insert query to populate your final table, converting text to dates at this point

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK