File names causing a problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

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'
 
You cannot have periods in a file name with the exception of identifying the
file extension (file type) .xls, .mdb, .txt, etc.
 
You cannot have periods in a file name with the exception of identifying the
file extension (file type) .xls, .mdb, .txt, etc.
Click to expand...

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.
 
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?
 
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
 
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.
 
Back
Top