General discussion

Locked

Importing a txt file into Access97

By dwooming ·
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.

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Importing a txt file into Access97

by SteveD In reply to Importing a txt file into ...

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

Collapse -

Importing a txt file into Access97

by dwooming In reply to Importing a txt file into ...

Poster rated this answer

Collapse -

Importing a txt file into Access97

by donq In reply to Importing a txt file into ...

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???

Collapse -

Importing a txt file into Access97

by dwooming In reply to Importing a txt file into ...

Poster rated this answer

Collapse -

Importing a txt file into Access97

by joescalia In reply to Importing a txt file into ...

try this: you can copy and paste ot type oit all in:

http://support.microsoft.com/support/kb/articles/Q160/9/54.asp?LN=EN-US&SD=gn&FR=0&qry=missing%20txt%20box&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC97

Good Luck

Collapse -

Importing a txt file into Access97

by dwooming In reply to Importing a txt file into ...

Poster rated this answer

Collapse -

Importing a txt file into Access97

by dwooming In reply to Importing a txt file into ...

This question was closed by the author

Back to Software Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums