R
Robjoy
I have to link or import a pile of files maintained by Lotus Approach (yuck)
as dBase 5 tables. Just one of them gives me a problem, it's called
StockAdjustment.dbf. If I use Link and browse to the file, Access says it
cannot locate the file StockAdjustment.dbf, even though it's there, as plain
as day, in the browse window.
If I try using VBA (DoCmd.TransferDatabase acImport, "dBase 5.0" etc.) I get
runtime error 3166 "Cannot locate the requested Xbase memo file". Eh?
Can anyone shine any light on what's different about this apparently
perfectly ordinary file, or how I can convince Access to eat it up like a
good boy? I'm stuck with opening it in Excel, saving it as an Excel file and
importing that - not satisfying.
as dBase 5 tables. Just one of them gives me a problem, it's called
StockAdjustment.dbf. If I use Link and browse to the file, Access says it
cannot locate the file StockAdjustment.dbf, even though it's there, as plain
as day, in the browse window.
If I try using VBA (DoCmd.TransferDatabase acImport, "dBase 5.0" etc.) I get
runtime error 3166 "Cannot locate the requested Xbase memo file". Eh?
Can anyone shine any light on what's different about this apparently
perfectly ordinary file, or how I can convince Access to eat it up like a
good boy? I'm stuck with opening it in Excel, saving it as an Excel file and
importing that - not satisfying.