Results 1 to 2 of 2

import spreadsheet

  1. #1
    slimjen is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2010

    import spreadsheet

    all, i want to transfer 2 spreadsheets from two different workbooks into 1 table in access 2003. i've search the transferspreadsheet code but the arguments are confusing.

    DoCmd.TransferSpreadsheet acImport, 3, _
        "Employees", "C:\Lotus\Newemps.wk3", True
    what does the 3 stand for? do I use two docmd lines to import 2 sheets into 1 table?

  2. #2
    apr pillai's Avatar
    apr pillai is offline Contributor
    Windows 7 64bit Access 2007
    Join Date
    May 2010
    Alappuzha, India
    If it is a one time operation then I think it is better if you try to link both XL Tables (or import them) into Access. Create Append Queries to transfer the data into the target table.

    You can even create a Query (without linking the xl tables into Access) refering the xl tables directly in the Query and add the data into the target table. You can learn this method from here.

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

Similar Threads

  1. Access 2010 Import Spreadsheet Wizard
    By frdebelo in forum Access
    Replies: 1
    Last Post: 06-20-2011, 12:11 PM
  2. import excel spreadsheet though outlook
    By bopsgtir in forum Import/Export Data
    Replies: 0
    Last Post: 03-18-2011, 09:07 AM
  3. Import 1 spreadsheet into two tables
    By Matthieu in forum Import/Export Data
    Replies: 4
    Last Post: 02-03-2010, 07:19 PM
  4. import an excell spreadsheet in an access database
    By lmichaud in forum Import/Export Data
    Replies: 0
    Last Post: 11-03-2006, 07:29 AM
  5. Problems with Import Spreadsheet Wizard
    By Conan Kelly in forum Import/Export Data
    Replies: 1
    Last Post: 11-29-2005, 08:39 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
Tech Forums: Microsoft Office Forums