DoCmd.TransferDatabase acImport - an Excel DBF

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

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
 
I seem to recall that there can be issues using long file names. Any chance
of reducing the file names to 8 characters?
 
Back
Top