runtime error 3274

Posted on 2006-04-17
Last Modified: 2008-01-09

I am trying to use the following to import an excel datasheet into MS access table.

DoCmd.TransferSpreadsheet acImport, 3, _
    "Report", "C:\Rep\Report.xls", True, "A1:L3000"

and I am getting
Runtime error 3274
External table is not in the expected format.

Please help.

Question by:spacetraveller
    LVL 77

    Accepted Solution

    Hi spacetraveller,
     DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, _
         "Report", "C:\Rep\Report.xls", True, "A1:L3000"

    Type 3 indicates it is a Lotus123 spreadsheet.


    Author Comment


    Thanks Pete, that problem is solved. I just left the argument blank. Also the spread sheet I was trying to import was in tab-delimited format. I had to change it into Excel spread sheet format. Do you have any solution for that?


    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Suggested Solutions

    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now