Importing files with a filename length of more then 8 characters

[Yke Hoekstra]

Hello friends,

I am trying to import a lot of paradox files into a ms access database, but
all the files have a length of 11 positions. Example: P2004-09-01.DB
I tried to import these files into an access database but it seems that it
accepts only files with 8 or less characters.
Files with more than eight characters produce the Microsoft Jet Database
Engine error 3011.
The filename consists important information, therefore I do not prefer to
rename the files.

Is there someone who can give me a simple solution for this problem?

Thanks in advance.


Greetings,

Yke

 

[Douglas J. Steele]

AFAIK, it's a limitation of the Paradox drivers. I don't believe there's any
option but to rename the files. You can always rename them temporarily, then
name them back.