Importing a excel file

[Accessme2]

Hi everyone,
I am using Access 2000 running windows xp and I am trying to import a spreadsheet.. the code is as follow:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel5, "TRANFER_XLS", "\\Server2008\CONTRACTING\Temp\Tranfer\" & Me.filename_in & ".xls", 1, "Sheet1!A1400"

and I get the following error:

'\\Server2008\CONTRACTING\Temp\Transfer\cresc3h1.xls' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.


I check the spelling and it seems correct and I have access to the server.. not sure what is the error.

Does anyone have any idea of what else to check????
thanks
Jorge

 

[ezfriend]

map that path to a drive letter and try to see if it can read the file.

 

[SOS]

Also, you have a typo it would seem

\\Server2008\CONTRACTING\Temp\Tranfer\"