Results 1 to 2 of 2
  1. 09-10-2012, 03:17 AM #1
    bambereczek
    bambereczek is offline Novice
    Windows XP Access 2003
    Join Date
    Sep 2012
    Posts
    1

    Importing Excel file to access


    Is it posible to import only some CELLs from excel file to access. for example i wont to import only A1 , B10 , E14 , C3 etc.?
    Reply With Quote Reply With Quote
  2. 09-10-2012, 06:38 AM #2
    JoeM
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    You can import Excel named ranges in Access.
    So if you name your range(s), you can import those as opposed to the whole sheet.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Importing excel file to append a table
    By vickan240sx in forum Access
    Replies: 1
    Last Post: 06-27-2012, 02:46 PM
  2. Importing .CSV file to excel
    By herbc0704 in forum Import/Export Data
    Replies: 1
    Last Post: 05-17-2012, 05:25 PM
  3. importing data from an excel file
    By slimjen in forum Access
    Replies: 3
    Last Post: 09-21-2011, 12:38 PM
  4. Importing an Excel file
    By bvtterflygirl in forum Import/Export Data
    Replies: 5
    Last Post: 02-24-2011, 11:54 PM
  5. can not delete the excel file after importing into database
    By dollygg in forum Access
    Replies: 0
    Last Post: 09-18-2009, 07:33 AM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums