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
 

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
Import Excel 2010 table into Access 2010 - not listed as range 1
Importing Multiple Excel Worksheets into An Access Table 4
error importing excel data to access table 2
Importing an Excel Worksheet to a Table in Access 2
Importing excel into access 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access-Excel Import Wizard problem 1

Back
Top