Import Extensionless files

[Jawad]

I want to import files in access without extension.
Winxp, Access 2003

When
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\TextDisabledExtensions
= txt,csv,!tab,asc,htm,html

I get message "You cannot import this file"

And when
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\TextDisabledExtensions
= !txt,csv,!tab,asc,htm,html

I get message "can not update. Data base or object is read only"

Please help, how can I import files without extensions.

Thanks
Jawad

 

[Douglas J. Steele]

Rename the file or make a copy of it with a valid extension, import it, then
either rename it back or delete the copy.

 

['69 Camaro]

Hi, Jawad.

I want to import files in access without extension.
Winxp, Access 2003

You can't. The security model built into Microsoft Office 2003 prevents
anything but the "approved" list of extensions from being imported by the
Import Wizard. A NULL string expression can't be negated by using the
Registry Key values, so a "blank" extension _can't_ be added to the
"approved" list.

You'll need to rename your files to use an extension before you'll be able
to import them into Access using the Import Wizard.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Jawad]

But with winxp, Office Xp, same probelm of extensionless file import was
solved by modifiying registery with ! sign. Why is it not working with Office
2003 bcoz I have hundreds of extensionless files to import.

Jawad

 

['69 Camaro]

But with winxp, Office Xp, same probelm of extensionless file import was

solved by modifiying registery with ! sign. Why is it not working with Office
2003

Office XP doesn't have exactly the same security model as Office 2003.
Office 2003 is designed to be more secure than Office XP, and that's not
always convenient for database developers or users.

I have hundreds of extensionless files to import.

Since you've already fixed the problem on your computer that has Office XP
installed, you can either:

1.) Use Access 2002 to import the extensionless files, then transfer the
tables to your Access 2003 computer, or
2.) Add extensions to the file names, and use Access 2003 to import them.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)