File names causing a problem

[Guest]

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'

 

[Guest]

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

 

[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.

 

[Guest]

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?

 

[John Nurick]

Wonder how many versions that code goes back?

Access v. 0.5 ?

 

[Guest]

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

 

[Guest]

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.