Results 1 to 6 of 6
  1. #1
    Lurmis is offline Novice
    Windows Vista Access 2007
    Join Date
    Sep 2009
    Posts
    4

    trnsferspreadsheet method - no data

    I have an issue where I call the transferspreadsheet method to export data from my adp to an excel spreadsheet. The export works on my machine. (Vista) but when I go to a user's machine(XP pro) the data does not transfer. There are no errors generated, it just leaves the spreadsheet blank. Any ideas?

  2. #2
    dcrake's Avatar
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    435
    Do you have another vista machine to test it on to see if it is machine or O/S specific. It could be to do with security and permissions.

    David

  3. #3
    Lurmis is offline Novice
    Windows Vista Access 2007
    Join Date
    Sep 2009
    Posts
    4
    I do, and I will. I don't think security is an issue. The user is a local admin to his machine, and has read/write permissions in the database. I'll post again with findings from the other Vista box. Thanks.

  4. #4
    Lurmis is offline Novice
    Windows Vista Access 2007
    Join Date
    Sep 2009
    Posts
    4
    This does work on the other Vista machine. What is missing on the XP box that would allow this to work?

  5. #5
    dcrake's Avatar
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    435
    Take a look at the references on the XP machine. Put a breakpoint on the command and track it through.

    David

  6. #6
    Lurmis is offline Novice
    Windows Vista Access 2007
    Join Date
    Sep 2009
    Posts
    4
    I am getting nothing. Is there a better way to transfer a record programmatically from a SQL database to an excel spreadsheet using an adp?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 08-05-2009, 04:07 PM
  2. Common Dialog control / ShowOpen method
    By phuile in forum Forms
    Replies: 0
    Last Post: 04-10-2009, 12:16 AM
  3. Replies: 2
    Last Post: 02-28-2009, 03:31 PM
  4. Find data, load data, and save as a new record
    By hawzmolly in forum Access
    Replies: 0
    Last Post: 10-05-2008, 03:18 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums