[AccessD] Reading DIF format (A97 etc)

On 12 Jul 2005 at 16:28, Griffiths, Richard wrote:

> Thanks, I was using A97 hence the confusion.
> 

For A97 replace: 
Split(strTemp,",")(1) with
Left$(strTemp,Instr(StrTemp,",") -1)
and
Split(strTemp,",")(2) with
Mid$(strTemp,Instr(StrTemp,",")+1)

-- 
Stuart