Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Importing / Linking / January 2005

Tip: Looking for answers? Try searching our database.

Importing files with a filename length of more then 8 characters

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Yke Hoekstra - 05 Jan 2005 23:21 GMT
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 - 06 Jan 2005 02:28 GMT
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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hello friends,
>
[quoted text clipped - 14 lines]
>
> Yke
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.