URGENT: FILE NAMES

  • Thread starter Thread starter terry
  • Start date Start date
T

terry

I have recently started using Access 2002. I am tryin to
use a function I have used many times before in Acces 97
using docmd.transfertext to import text files. When
specifying the file names I have normally used a wildcard
to account for dates on file names i.e a file named
file080604.csv would be file*.csv.

When I have tried to use this same format in Access 2002
I get the message file cannot be found. Can anyone help?
 
Hum, I never knew you *could* use a wild card for transfer text.

I guess you could use the dir command to grab the name...and feed that to
transfertext.

Check out the dir command in help..
 
I have recently started using Access 2002. I am tryin to
use a function I have used many times before in Acces 97
using docmd.transfertext to import text files. When
specifying the file names I have normally used a wildcard
to account for dates on file names i.e a file named
file080604.csv would be file*.csv.

When I have tried to use this same format in Access 2002
I get the message file cannot be found. Can anyone help?
Click to expand...

Please post your code.
 
the code I am using is

DoCmd.TransferText acImportDelim, "CCAT_Hierarchy", _
"tblCCAT", "P:\ccppro_ss_ccat_people*.csv", Yes
 
Back
Top