Wizhook error message when trying to import text file

[Christine]

Hi group,

I was recently upgraded to Office 2007 and I was relieved to see that my old
databases still worked with it, for the most part. The one part that does not
work at all seems to be importing text files to my database.

In my database, I have a table made up of keywords. I compare new lists of
words to this master list to see what words I need to add.

In the past, I simply imported the updated master list as a text file every
month to my database with no problems.

Now when I try to do the same action, I get this error message after
clicking finish:

Method 'ExecuteTempImexSpec' of object '_WizHook' failed

What causes this error and how can I import my text file?

Thanks,
Christine

 

[Gina Whipp]

Christine,

I did a search on your error as I've never seen that before. Looks like the
file might have some corruption and/or a field that Access 2007 can't
resolve. Recommendations suggest opening the file and removing the
offending record or field.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index.htm

 

[Graham R Seach]

Christine,

'ExecuteTempImexSpec' is not part of the Wizhook library. At least I can't
see it in the WizHook interface. It could be that it's *really* hidden and
the import wizard uses it internally, or it could be that someone added a
call to it somewhere in your app, but failed to supply the key.

I'd start by search for the word "WizHook" in your application and see if
the key has been correctly entered:
WizHook.Key = 51488399

If that isn't it, then all the reading I've done suggests it could be that
you're using the delimited option in your spec on a file that doesn't
actually have delimiters in it. Try using fixed-length instead.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Christine]

Hi Gina,

Thanks for the suggestion. I was wondering that myself. The list of words is
well over 60,000, so it would be quite a needle in the haystack. Fortunately
Graham's solution, to import it as fixed width instead of delimited solved
the problem.

Best,
Christine

 

[Christine]

Dear Graham,

Thanks so much! That did the trick. I couldn't think of where I would have
knowingly used Wizhook in my database, so I'm glad it was a simple fix. Now I
can get back to comparing words

Best,
Christine