• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 719
  • Last Modified:

runtime error 3274

Hi

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.

Thanks,
st
0
spacetraveller
Asked:
spacetraveller
1 Solution
 
peter57rCommented:
Hi spacetraveller,
 DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, _
     "Report", "C:\Rep\Report.xls", True, "A1:L3000"

Type 3 indicates it is a Lotus123 spreadsheet.


Pete
0
 
spacetravellerAuthor Commented:

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?

Thanks,
st
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now