Software

Ask something
Discussion Locked

Importing a txt file into Access97

0 helpful
7 replies

by dwooming

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

When I try to import a txt file to an access database, I do not have that option in the drop down list. The drpo down is missing txt and html extensions.

I tried reinstalling office 97, choosing a custom install, and making sure that these were selected in the data access portion. They were checked and greyed out showing that they were already installed.

I also tried installing the 97 value pack, this did not help either.

I upgraded the OS from 98 to 98SE, still no luck.

Every othermachine that has office 97, has these extensions in the drop down by default.

What could be the problem?

Thanks in advance.

7 replies

by steved

Hard to answer directly without looking over your shoulder. It sounds as if you've looked for all the right things.

Have you thought of trying an indirect approach? Do you have the text file import option in Excel? Do you have the Excel import option in Access? If so, perhaps you could accomplish your imports in two steps.

I hope this helps.

Steve Diamond

by donq

It sounds as though your PC's copy of Access does not have one or more of the required DLL libraries open.

You might try Tools | ActiveX Controls from the menu bar???

This discussion is closed to new replies.