DoCmd.TransferDatabase acImport - an Excel DBF

[Guest]

N = "Store" & cboTheMonth & Right(cboStoreYr, 2) & ".dbf"
DoCmd.TransferDatabase acImport, "dbase IV", _
"S:\SelfAud", acTable, N, "StoreData", False

Have done this many times w/ DBF files. In this case, running the code
gives an error that it's not in the Path..."S:\SelfAud\Store0607.DBF" - which
it is.

H E L P...TIA - Bob

 

[Douglas J. Steele]

I seem to recall that there can be issues using long file names. Any chance
of reducing the file names to 8 characters?

 

[Guest]

Doug - That was it...Now I remember that from several years ago.

Thank you - Bob