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?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Bob Barnes" <(E-Mail Removed)> wrote in message
news:BB65408F-06CF-4AA0-853E-(E-Mail Removed)...
>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

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

Thank you - Bob


"Douglas J. Steele" wrote:

> I seem to recall that there can be issues using long file names. Any chance
> of reducing the file names to 8 characters?
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "Bob Barnes" <(E-Mail Removed)> wrote in message
> news:BB65408F-06CF-4AA0-853E-(E-Mail Removed)...
> >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
>
>
>