Results 1 to 4 of 4
  1. 09-21-2011, 12:14 PM #1
    waqas
    waqas is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    117

    Smile Excel sheet open in recordset


    hi all,

    how can i import excel sheet into recordset?
    Reply With Quote Reply With Quote
  2. 09-21-2011, 01:00 PM #2
    Robeen
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    Click External Data -> Excel -> and then follow the prompts in the dialog box that pops up.

    Hope this helps!
    Reply With Quote Reply With Quote
  3. 09-22-2011, 11:43 AM #3
    waqas
    waqas is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    117

    Red face

    oh my dear,

    i want to import by ADO recordset.

    how can i do it.

    any expert can tell me code.
    Reply With Quote Reply With Quote
  4. 09-22-2011, 11:47 AM #4
    Robeen
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    Oops! Sorry. I mis-understood.

    Please post again in a new thread.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. VBA to create Excel sheet and a copy as PDF
    By MichaelC in forum Programming
    Replies: 2
    Last Post: 05-04-2011, 02:32 PM
  2. Creating or Populating an Excel sheet from Access
    By toddbailey in forum Access
    Replies: 1
    Last Post: 03-02-2011, 03:08 PM
  3. How to split an excel sheet with all data into a one-to-many relationship?
    By kawi6rr in forum Access
    Replies: 4
    Last Post: 10-07-2010, 04:45 PM
  4. Import Excel sheet with query
    By tpcervelo in forum Queries
    Replies: 1
    Last Post: 08-03-2010, 07:10 PM
  5. Importing Excel Sheet into Access dbase
    By tonystowe in forum Import/Export Data
    Replies: 0
    Last Post: 12-08-2006, 11:35 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