Importing data - check if field in table is populated?

[chuckles1066]

I have to import data daily into a table.

The table has an extra field named "Import Date"........after each import, I run a query that asks me for a date, I input today's date and it updates any rows in that field that are null.

But if I forget to run the query and then perform a subsequent import............

So......is there a way somehow to interrupt the whole File / Get External Data / Import thing with a "there is data in the table that hasn't been updated" routine (which checks for a null value in the "Import Date" field).

XP is the Office version.

 

[boblarson]

If you use File > Get External Data > Import then there is no way to interrupt that. But if you do the import using code then you can use

If DCount("*", "tableNameHere", "[Import Date] Is Null) > 0 Then
   MsgBox "There are records with no import date already in the table!", vbExclamation
Exit Sub
End If

 

[chuckles1066]

Many thanks Bob, I may have to go down the code route.

Life's full of learning curves