Excel Import goes thru without any data

H

Hadi

Experts,

I have been importing excel data to Project for years and never seen this
problem. Today I was helping one of our users to import a list of assignments
from Excel to a project schedule. We opened the excel file and went through
the import wizard until we got to Finish. it went through but no data came
in. I tried the same excel and same project files on my computer and
everything worked fine. I did see that he did not have the "allow files with
legacy format to open", but when I checked it didnt help either. what ami
missing

Hadi
 
J

JulieS

Hadi,

What did you set as the merge key? Can you give us more details
about the merge fields you are using?

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project
 
A

Andrew Lavinsky

What're you using for the Primary Key? Is it possible that got changed on
the user machine?
 
H

Hadi

This was an Append taks or Merge so I did not use a merge key, plus i took
the same project schedule and excel sheet, tried it on my machine and work
perfectly
 
J

JulieS

If it works fine on your computer and does not function on
another, I've got to guess it is not specific to Project. Things
to check:
Same version of Excel?
Same SP to Excel and Project?
Same OS?

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project
 
H

Hadi

all versions are matching. I would have to check the SP. we'll get back to
you on Tuesday. Thanks so much Julie
 

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

How to import Start/Finish Data from Excel 1
Project 2010 "Project has stopped working" error when attempting to import from Excel 0
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Copy and Paste Special in Excel #REF error 1
Excel import problem - xpost from question in Project Server group 1
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
Missing data after importing a project from excel 3
Linking data in MS Word into Excel 5

Top