Results 1 to 3 of 3
  1. #1
    JayX is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2011
    Posts
    62

    Exclamation Importing Excel Spreadsheet

    Is there anyway to import my excel spreadsheet which contains command buttons with vba code into access?



    Help would be much appreciated, thanks.

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    Not ever having needed to do that I would say not in terms of the traditional definition of 'import' - which is bring in structured data into tables.

    I think you would want to copy/paste the vba - - and then tweak....

    Sorry not to be more helpful.

  3. #3
    JayX is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2011
    Posts
    62
    So i can copy the command buttons from excel into access?

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

Similar Threads

  1. Only importing a specific spreadsheet-vba
    By Lorlai in forum Access
    Replies: 1
    Last Post: 09-08-2011, 05:26 PM
  2. Importing Spreadsheet
    By derfalpha in forum Access
    Replies: 1
    Last Post: 01-04-2011, 10:47 AM
  3. Importing Excel 2007 spreadsheet into Access 2002
    By jhjr in forum Import/Export Data
    Replies: 1
    Last Post: 06-17-2010, 02:05 PM
  4. importing excel spreadsheet issues
    By majortool in forum Import/Export Data
    Replies: 1
    Last Post: 01-24-2008, 06:29 PM
  5. Type error when importing Excel spreadsheet
    By jlmnjem in forum Database Design
    Replies: 2
    Last Post: 08-27-2006, 07:26 PM

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