Re: subscript out of range

willy k-

are you sure the excel file matches the access table in range, format,
etc? 
I am still waiting for my client to download the update to see if that
fixes 
the issue. I'll let you know if i find a solution.

"willy k" wrote:

> patti : Thank you, I went ahead and did a detect and repair, I also 
> downloaded service pack 1 for office 2007. Unfortunately the problem of
the 
> subscript out of range still exists.  
> 
> "patti" wrote:
> 
> > Willy-
> > 
> > Did you do a detect and repair to Access 2007? Do you have the latest 
> > updates applied?
> > 
> > "willy k" wrote:
> > 
> > > Hi Patti: No I haven't gotten an answer or a response. I may post
the 
> > > question again. Then whats the use. Thanks for your intrest.
> > > 
> > > willy 
> > > 
> > > "patti" wrote:
> > > 
> > > > willy k-
> > > > 
> > > > did you ever find out an answer to this?
> > > > 
> > > > thanks.
> > > > 
> > > > patti
> > > > 
> > > > "willy k" wrote:
> > > > 
> > > > > p.s. I should note that we are im****ting into an existing talbe,
in other 
> > > > > words appending the table.
> > > > > 
> > > > > Thanks 
> > > > > Willy
> > > > > 
> > > > > "pietlinden@[EMAIL PROTECTED]
" wrote:
> > > > > 
> > > > > > On Aug 4, 8:46 am, willy k <wil...@[EMAIL PROTECTED]
>
wrote:
> > > > > > > We im****t a text file into an access table, then we im****t
an excel
> > > > > > > file into another access table. we get the "subscript out of
range" error
> > > > > > > message. we close access and open it again, then the excel
file im****ts
> > > > > > > fine. any
> > > > > > > ideas on a fix for this?
> > > > > > >
> > > > > > > thanks
> > > > > > > willy
> > > > > > 
> > > > > > How are you doing the im****t?  in code?
> > > > > >