Trouble importing data from Excel... (1 Viewer)

[naradmuni]

Hi - can anyone help? I'm a beginner to Access and am trying to import data from an Excel file to a new Access database. When I go through Create New Table and try and import, it pops up an error message saying 'ActiveX Controls Can't Create Object'....what am I supposed to do??

 

[Pat Hartman]

Look up this message in the archives here or in the Microsoft knowledge base -
http://support.microsoft.com/support/c.asp?FR=0

 

[cdacey]

I have always used the File, Import data commad, to import to access from excel. You can import to an existing table or create a new table this way, and then run an append query to add to an existing table if you need to. The thing with importing is to be sure the field types are the same and I usually make sure the field order is also the same in excell before trying to import.
Good Luck