Maximum/Minimum number of records on import

  • Thread starter Thread starter shmoussa
  • Start date Start date
S

shmoussa

My database is set to import a CSV. Is there a way to not allow a CSV
file to be imported, and bring up a message box if the CSV file has
less than 30 records or more than 500 records? I think it involves
something to do with Select Case, but I'm not quite sure where to take
it from there.
 
Rather than a direct import, set it up as a Link. Then you can address the
file like a recordset and determine whether or not to do the import. Then do
the import with a query.
 
Thank you for your response. I already have the actual importing
process working perfectly the way I want it. But I was wondering
whether or no there was some type of code to stick in there, to tell
it not to allow importing of a CSV file with less than 30 or more than
500. If there is a code that I can just add, let me know. Thank you
again.
 
Dave's suggestion is the most reasonable one.

Link to it, then do a count on how many rows are in the linked table. If the
count is outside of the allowable range, display the message. If not, do
your import.
 
Back
Top