Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Location
    Singapore
    Posts
    28

    Question Unanswered: Export Access to Excel \ Export table with password

    Hi all,

    Is there any way that I can import an Excel file (require password for open & modify) into an Access Database? Also the other way round export from Access db to excel file.

    Or is there any way that I can export a table that has a password field, to an excel file without revealing the password?

    Regards,
    oks

  2. #2
    Join Date
    Sep 2004
    Posts
    161
    For your first question
    With Access basic (TfransferSpreadSheet) I think no but with Excel object (Workbook, Range, etc..) using in VBA you can import/export from/to protected file.
    But i dont understand your second question, if you use Access you are already connected

Posting Permissions

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