File names causing a problem

A

AccessHar

I am using the following function

DoCmd.TransferText acImportDelim, , _
"TBL_All_CSV_RECORDS", Path & Reports_Dirs,
False

The Reports_DIRS is a file name for e.g.
20070420111907-caresponse.uni1.W0003260.csv

The code gives a Runtime Error 3011, saying "The Microsoft Access Database
engine could not find the object
'20070420111907-caresponse.uni1.W0003260.csv', make sure the object exists
and that you spelt its name and the path name correctly.

Can Access not handle file name of the form
'20070420111907-caresponse.uni1.W0003260.csv'
 
K

Klatuu

You cannot have periods in a file name with the exception of identifying the
file extension (file type) .xls, .mdb, .txt, etc.
 
J

John Nurick

You cannot have periods in a file name with the exception of identifying the
file extension (file type) .xls, .mdb, .txt, etc.

Hi Dave,

This seems to be a limitation in Access's import/linking routines.

Recent versions of Windows have no problems with multiple periods, and
I've just discovered by experiment that the antique VBA File I/O
statements (Open, Print #, etc.) work with them too.
 
K

Klatuu

Are you saying DOS has been replaced? Wow, when did this happen?
Actually, John, I was not aware multipe periods were okay with Windows. I
guess it is just old habits; however, I do know exporting and importing with
them in Access is a problem. Earlier this week I had to help my wife
(world's worst user) with some imports for work and she was having this
problem.
Wonder how many versions that code goes back?
 
A

AccessHar

FYI, I am the person who raised the original problem, I am not using any old
versions of Microsoft products, I an on Windows Vista and have Access 2007.
That is not the problem, the Code actually recognised the Field name but the
functione to import the CVS doesn't see my oroginal mail
 
K

Klatuu

That is what we were discussing, the fact that the import/export routines
don't recognize file names with multiple periods. Obviously, the code behind
them has not changed.
 

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

Top