• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 728
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

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