subscript out of range

  • Thread starter Thread starter willy k
  • Start date Start date
W

willy k

We import a text file into an access table, then we import 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 imports
fine. any
ideas on a fix for this?

thanks
willy
 
We import a text file into an access table, then we import 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 imports
fine. any
ideas on a fix for this?

thanks
willy
Click to expand...

How are you doing the import? in code?
 
We are using office 2007 proffesional. We go to the external data tab then
click on text file and use that wizard. Next we click on excel and use that
wizard.

Thanks for your help
Willy
 
p.s. I should note that we are importing into an existing talbe, in other
words appending the table.

Thanks
Willy
 
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
 
Willy-

Did you do a detect and repair to Access 2007? Do you have the latest
updates applied?
 
Back
Top