Is this a one time thing or a regular occurrence? If it's regular, have you looked at DTS? You can use the Import wizard from EM to create a package that will do this.
Are you sure the SQL Server database engine service account has rights to read the file? This has nothing to do with your rights or your workstation. The path and security must be from the server instance.
Editor: moved to SQL 2000