Importing an ASCII or DBase III file

C

ChuckW

Hi,

I exported a file from a system call Time Matters. The
two main choices I had was ASCII and DBase III. After I
created the ASCII file, I tried importing it using All
File but Access could not recognize it. I then tried
saving it as a DBase III file. When I tried importing it
by selecting DBase as the File of Type, the file name
appears in the dialogue box. When I try and select it, I
get a message that says "The Microsoft Jet Database
engine could not find the object 'Time_Matters.DBF'.
Make sure the object exists and that you spelled its name
and path name correctly.

Any idea why I cannot import this?

Thanks,

Chuck
 
J

John Nurick

Hi Chuck,

The dBase import routine seems to need old-style 8.3 filenames and
paths. Either specify the short equivalent of the path or move and
rename the file so there are no long names in the path and its total
length is less than 64 characters.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ACC2007: numeric fields truncated when imported from dBase III fil 1
Creating an Access database file from a dbf (dbase) file 5
Linking a dBase III file with the 'wrong' extension 3
Active Content in this file is blocked issue 1
Writing FLOATs to dBase III tables 0
Jet 4 Drivers and dBase III Access 4
Export an Access Table as an dbase III file 8
Import of dbase files 3

Top