From Excel to Access data import

S

Scott

I'm trying to take a table in Excel and import it into
Access. Below is a simplified example of what I'm trying
to do. Cell A1 contains "Model" and cell E3 contains "5"
for Jan units on part xyz. In Excel, I went Data-
Convert to MS Access and I got the error message "The
Click to expand...
Microsoft Jet database engine could not find the
object '<$R1C1:R3C5>. Make sure the object exists and
that you spell its name and the path name correctly."

Is there something that I'm missing? All I'm trying to do
is get my Excel data into Access and I can't seem to get
it done. I am constantly getting this error message.
Thanks in advance for your help.


Model Fcst NovUnits DecUnits JanUnits
abc Oct 3 8 7
xyz Oct 9 1 5
 

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

Adding data to MS Access from csv file 0
Import data from excel 1
Import Excel 2010 table into Access 2010 - not listed as range 0
Copy and paste slide from one presentation to another presentation gives an error 2
Linking data in MS Word into Excel 5
Import query criteria from Excel 0
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Import Data from Excel 2

Top