Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Gillingham, Kent, England
    Posts
    511
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Confirmation about transferspreadsheet. (Access 97 SR2)

    Im sure I remember reading that the transferspreadsheet method can't export to a network path, but I can't find where I read it. Is this true or did I imagine it?

    Must get myself a new memory!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Confirmation about transferspreadsheet. (Access 97 SR2)

    There are some newsgroups posts mentioning problems with TransferSpreadsheet using an UNC path. See here. Unfortunately, I can't test at the moment.

  3. #3
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Confirmation about transferspreadsheet. (Access 97 SR2)

    I never had problem exporting spreadsheet to network drive using TransferSpreadsheet with either mapped drive letter or UNC path. Example:

    <code>Public Sub TestTransferSpreadsheetUNCPath()</code>
    <code> DoCmd.TransferSpreadsheet Transfertype:=acExport, _</code>
    <code> SpreadsheetType:=acSpreadsheetTypeExcel8, _</code>
    <code> TableName:="Customers", _</code>
    <code> FileName:="ServerNameShareNameABX00100XTempCustome rs.xls"</code>
    <code></code>
    <code>End Sub</code>

    This worked correctly on WIN 2K network, using Access 2K. Cannot verify if works with ACC 97 or on WIN 9X system. If error results when exporting with UNC path specification, recommend resolve UNC path to a mapped network drive letter path, then export. Various methods can be used to derive mapped drive from UNC path if necessary, can post examples.

    HTH

  4. #4
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Gillingham, Kent, England
    Posts
    511
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Confirmation about transferspreadsheet. (Access 97 SR2)

    Thanks for the link Hans. Reading through those newsgroup replies it seems people with Access 97 can't export to a UNC path and people with Access2000 or later can, so it looks like one of those problems that got fixed with the updated version.

    Thanks for your reply too Mark. For now I'm not after a resolution, I was just after confirmation. The problem was happening on terminal server and I wanted confirmation that it wasn't the way the server was set up. Hans' link provides a 3rd party that is having the same problem, that's all I need at the moment. Thanks.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Confirmation about transferspreadsheet. (Access 97 SR2)

    To confirm MarkD's reply: I just tested it and had no problem exporting to a UNC path (Access 2002)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •