activex component can't create object

R

Robert Blackwell

I was trying to create a table by importing an excel sheet, then I also
tried creating the table from scratch using the same column names and when I
chose file>get external data> import

I get the same error again.

basically I have a TON of excel files each with only maybe 1-20 records
each, all using the same table structure. I want to import them into one big
table.

I've tried an excel macro to import all the sheets into one excel file but I
can't merge all the sheets into one.
 
K

Kristyn Wagoner [MSFT]

Hey Robert -

Take a look at this article for some common causes of this message.

319841 ACC2000: Error Message: ActiveX Component Can't Create Object
http://support.microsoft.com/?id=319841

--
Kristyn Wagoner
Microsoft PSS

Please do not reply directly to this alias. This alias is for newsgroup
purposes only.

This posting is provided "AS IS" with no warranties, and confers no rights.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

import excel - ActiveX component can't create object 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
ActiveX component can't create object 9
Import data from excel into access tables 2
Turning a 3 column flat file into a "3D" Table 2
Activex component can't create object 1
Error while import Excel file to Access 6
Import to many to many table 7

Top