importing an excel dowloaded worksheet to an access table

  • Thread starter Thread starter LBJ
  • Start date Start date
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!!!
 
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
 
Back
Top