importing an excel dowloaded worksheet to an access table

L

LBJ

I am trying to import and excel worksheet that was downloaded from another
data source. when i go import, select the file and then access starts to
work but stops and indicates "there is no object in this control". I have
recopied the excel sheets and saved it as a CSV file but keep getting the
same message! HELP!!!
 
M

Mark A. Sam

LBJ,

It sounds like a data problem. Check the data in the spreadsheet for
anything unusual. Maybe even a single cell has something that Access doesn't
recognize. Something you may try is selecting the data from the spreadsheet
and pasting it into a new Access table. copy the headings and data, from
the spreadsheet, open a new Access table in Datasheet view. Then click on
the corner of the open table where the rows and columns come together and
paste. Then open the table in design view and adjust the data types.

God Bless,

Mark
 

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

importing a worksheet info to an existing access table 2
Importing an Excel Worksheet to a Table in Access 2
Importing an Excel File 1
Access Subscript out of range when importing into access 2010 from excel 0
Importing from Excel to Access 1
Problems importing an excel worksheet into an existing access data 1
Access Importing csv daily files into access 2007 1
Importing Excel Data into MS Access Table 1

Top