Importing Macro Problem

C

craig

I am trying to design a macro which will import a specific
file (txt or xls) which resides in the same folder as the
database. I have type the file path for the import
as .\leave codes.xls, which successfully imports the
file. However when I close the database and reopen I get
an Error message stating that the MS Jet cannot locate the
object M:\leave codes.xls. I have M:\ set as my default
database folder in Options. If I remove this path, the
error changes to MS Jet cannot locate the object H:\leave
codes.xls, H:\ drive being my normal system default drive.

I am using Windows XP and Access 2002, is this the issue?

Please help!
..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working outlook via vba code with xlsx - error 0
ISO best steps to export (import) all from Outlook 2003 to Outlook in MS 365 0
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Macro doesn't work any more 0
Adding a folder results in error in currently working database 4
Ignore table formatting when importing data using OLEDB 0
"Compile error in table level validation expression " after format 0

Top