Load file from a network

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

I have a database which is on a server. I have a command
button to load data in to it as a table form a
spreadsheet. In order for it to work I have a folder on
the local HD with the same name. It works, however, just
had a Domain change. I still have access to the same
drives but now I get an invalid path. Here was the code

DoCmd.TransferSpreadsheet acImport,
acSpreadsheetTypeExcel8, "Worksheet", "\ReportUtility\repor
t.xls", True

Now I can get it to work if I do "c:\ReportUtility...."

Any suggestions on getting it back to non drive specific?
or a better way in general?
 
Hello Dan,

Sounds like you were using a shared folder on the server. First, check if
the folder is still on the server as shared. If it is then just remap it to
a drive on your machine and use that.

Ragnar
 
Back
Top