[AccessD] Excel & CSV File Import

Stuart McLachlan stuart at lexacorp.com.pg
Thu Aug 7 16:55:46 CDT 2003


On 7 Aug 2003 at 23:18, ACTEBS wrote:

> Stuart,
> 
> Thanks for that. All works great, but I get a sub script out range error
> when the line feed gets to a blank/null row. Any ideas on how I can handle
> that?
> 

Test for the blank line.
If strTemp >  ""   Then
  'parse the line and do your manipulation
Else 
  'skip the line
End If

 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.





More information about the AccessD mailing list