Right-click to open TXT in Access Fails

[Al]

We can import TXT files directly into Access 2002 using the Wizard, but when
trying to use the right-click, Open with MS Access from Windows Explorer, we
get this error:

Unrecognized database format 'G:\datasetname.txt'.

Any idea how to repair this?

Thanks
Al

 

[Jeanette Cunningham]

Al,
You can import a txt file into Access. You won't be able to open a txt file
by right click and choose Open with MS Access from Windows Explorer.
That is how access is. If you want to open a database using the right-click,
Open with MS Access from Windows Explorer, you need to use either a .mdb
file or .mde file. Was there something else you were trying to achieve with
your database?

Jeanette Cunningham

 

[Al]

This actually does work in Windows XP, I found a solution which I'd like to
share

Click Start, Run then paste the following line in the Open: box and press
Enter
regsvr32 "C:\Windows\system32\Msexcl35.dll" /u

Repeat but use the following line in the Open: box
regsvr32 "C:\Windows\system32\Msexcl35.dll"

Problem was resolved afterwards. Right-click and Open with MS Access opens
the text import wizard and creates an MDB from the comma delimitted txt file

Thanks for responding
Al

 

[Jeanette Cunningham]

Thanks for sharing, I always like to learn something new about Access.

Jeanette Cunningham