[AccessD] Excel & CSV File Import

Stuart,

Thanks for that...worked a treat...

Vlad

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Friday, 8 August 2003 7:56 AM
To: ACTEBS; accessd at databaseadvisors.com
Subject: RE: [AccessD] Excel & CSV File Import


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.



_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com