Importing selected fields from MS Access 2003 into new MS Project

[Norman Levinson]

(MS Project nube)

First, thanking you in advance.

I am importing certain fields from an Access 2003 dB table using the Import
Wizard within MS Project. Some of the fields are mapping correctly and
importing e.g. Actual Start Date and Task (Name). When I map Duration to
either Duration or Actual Duration or Estimate Duration it is not recognizing
this mapping and setting all imported "Duration" records to 0.

I am mapping as follows:

Access 2003 Field MS Project field

App_Name Name
Design_Start_Date Actual Start
Duration Duration



Note: The "Map Options" on the Import Wizard provide:

[X ]Tasks
[ ]Resources
[ ]Assignments

I am mapping to a table created via a Make Table query. When I check only
Tasks I get through the Wizard but it defaults all Durations to 0 But if I
check more than this option I cannot get through the Wizard. It keeps stating
"The Source table name is required". It is designated but I keep getting
this error.

Thanks!

 

[John]

(MS Project nube)

First, thanking you in advance.

I am importing certain fields from an Access 2003 dB table using the Import
Wizard within MS Project. Some of the fields are mapping correctly and
importing e.g. Actual Start Date and Task (Name). When I map Duration to
either Duration or Actual Duration or Estimate Duration it is not recognizing
this mapping and setting all imported "Duration" records to 0.

I am mapping as follows:

Access 2003 Field MS Project field

App_Name Name
Design_Start_Date Actual Start
Duration Duration



Note: The "Map Options" on the Import Wizard provide:

[X ]Tasks
[ ]Resources
[ ]Assignments

I am mapping to a table created via a Make Table query. When I check only
Tasks I get through the Wizard but it defaults all Durations to 0 But if I
check more than this option I cannot get through the Wizard. It keeps stating
"The Source table name is required". It is designated but I keep getting
this error.

Thanks!

Norman,
My quick guess is that Project is receiving the duration data but you
don't recognize it because it is in minutes. All time based data in
Project is held in Project's underlying database in tenths of minutes.
So if you import a task with a 10 day duration (Access), it will come
across as 10 minutes in Project. However, if the default duration
(Tools/Options/Schedule tab) is set to display days in the duration
field, those 10 minutes will display as "0" days.

Try converting your Access duration data to minutes and then see how it
works.

Hope this helps.

John
Project MVP

 

[Norman Levinson]

so since my Duration is in days to convert to minutes I should, for example,
10 days => 10 x 8hr/day X 60 min/hr = 4800 minutues. Thank you John...will
let you know.

(MS Project nube)

First, thanking you in advance.

I am importing certain fields from an Access 2003 dB table using the Import
Wizard within MS Project. Some of the fields are mapping correctly and
importing e.g. Actual Start Date and Task (Name). When I map Duration to
either Duration or Actual Duration or Estimate Duration it is not recognizing
this mapping and setting all imported "Duration" records to 0.

I am mapping as follows:

Access 2003 Field MS Project field

App_Name Name
Design_Start_Date Actual Start
Duration Duration



Note: The "Map Options" on the Import Wizard provide:

[X ]Tasks
[ ]Resources
[ ]Assignments

I am mapping to a table created via a Make Table query. When I check only
Tasks I get through the Wizard but it defaults all Durations to 0 But if I
check more than this option I cannot get through the Wizard. It keeps stating
"The Source table name is required". It is designated but I keep getting
this error.

Thanks!

Norman,
My quick guess is that Project is receiving the duration data but you
don't recognize it because it is in minutes. All time based data in
Project is held in Project's underlying database in tenths of minutes.
So if you import a task with a 10 day duration (Access), it will come
across as 10 minutes in Project. However, if the default duration
(Tools/Options/Schedule tab) is set to display days in the duration
field, those 10 minutes will display as "0" days.

Try converting your Access duration data to minutes and then see how it
works.

Hope this helps.

John
Project MVP

 

[John]

so since my Duration is in days to convert to minutes I should, for example,
10 days => 10 x 8hr/day X 60 min/hr = 4800 minutues. Thank you John...will
let you know.

Norman,
Right. Go for it.

John

(MS Project nube)

First, thanking you in advance.

I am importing certain fields from an Access 2003 dB table using the
Import
Wizard within MS Project. Some of the fields are mapping correctly and
importing e.g. Actual Start Date and Task (Name). When I map Duration to
either Duration or Actual Duration or Estimate Duration it is not
recognizing
this mapping and setting all imported "Duration" records to 0.

I am mapping as follows:

Access 2003 Field MS Project field

App_Name Name
Design_Start_Date Actual Start
Duration Duration




Note: The "Map Options" on the Import Wizard provide:

[X ]Tasks
[ ]Resources
[ ]Assignments

I am mapping to a table created via a Make Table query. When I check only
Tasks I get through the Wizard but it defaults all Durations to 0 But if
I
check more than this option I cannot get through the Wizard. It keeps
stating
"The Source table name is required". It is designated but I keep getting
this error.

Thanks!

Norman,
My quick guess is that Project is receiving the duration data but you
don't recognize it because it is in minutes. All time based data in
Project is held in Project's underlying database in tenths of minutes.
So if you import a task with a 10 day duration (Access), it will come
across as 10 minutes in Project. However, if the default duration
(Tools/Options/Schedule tab) is set to display days in the duration
field, those 10 minutes will display as "0" days.

Try converting your Access duration data to minutes and then see how it
works.

Hope this helps.

John
Project MVP

 

[Norman Levinson]

Like you said, in tenths of minutes so I was off by a factor of 10. Wrote an
update query and added *10 against 48 projects within Access. Very nice. All
projects imported perfectly. Thank you very much.

so since my Duration is in days to convert to minutes I should, for example,
10 days => 10 x 8hr/day X 60 min/hr = 4800 minutues. Thank you John...will
let you know.

Norman,
Right. Go for it.

John

(MS Project nube)

First, thanking you in advance.

I am importing certain fields from an Access 2003 dB table using the
Import
Wizard within MS Project. Some of the fields are mapping correctly and
importing e.g. Actual Start Date and Task (Name). When I map Duration to
either Duration or Actual Duration or Estimate Duration it is not
recognizing
this mapping and setting all imported "Duration" records to 0.

I am mapping as follows:

Access 2003 Field MS Project field

App_Name Name
Design_Start_Date Actual Start
Duration Duration




Note: The "Map Options" on the Import Wizard provide:

[X ]Tasks
[ ]Resources
[ ]Assignments

I am mapping to a table created via a Make Table query. When I check only
Tasks I get through the Wizard but it defaults all Durations to 0 But if
I
check more than this option I cannot get through the Wizard. It keeps
stating
"The Source table name is required". It is designated but I keep getting
this error.

Thanks!

Norman,
My quick guess is that Project is receiving the duration data but you
don't recognize it because it is in minutes. All time based data in
Project is held in Project's underlying database in tenths of minutes.
So if you import a task with a 10 day duration (Access), it will come
across as 10 minutes in Project. However, if the default duration
(Tools/Options/Schedule tab) is set to display days in the duration
field, those 10 minutes will display as "0" days.

Try converting your Access duration data to minutes and then see how it
works.

Hope this helps.

John
Project MVP

 

[John]

Like you said, in tenths of minutes so I was off by a factor of 10. Wrote an
update query and added *10 against 48 projects within Access. Very nice. All
projects imported perfectly. Thank you very much.

Norman,
You're welcome and thanks for the feedback.

John
Project MVP

so since my Duration is in days to convert to minutes I should, for
example,
10 days => 10 x 8hr/day X 60 min/hr = 4800 minutues. Thank you
John...will
let you know.

Norman,
Right. Go for it.

John

:

(MS Project nube)

First, thanking you in advance.

I am importing certain fields from an Access 2003 dB table using the
Import
Wizard within MS Project. Some of the fields are mapping correctly
and
importing e.g. Actual Start Date and Task (Name). When I map Duration
to
either Duration or Actual Duration or Estimate Duration it is not
recognizing
this mapping and setting all imported "Duration" records to 0.

I am mapping as follows:

Access 2003 Field MS Project field

App_Name Name
Design_Start_Date Actual Start
Duration Duration





Note: The "Map Options" on the Import Wizard provide:

[X ]Tasks
[ ]Resources
[ ]Assignments

I am mapping to a table created via a Make Table query. When I check
only
Tasks I get through the Wizard but it defaults all Durations to 0 But
if
I
check more than this option I cannot get through the Wizard. It keeps
stating
"The Source table name is required". It is designated but I keep
getting
this error.

Thanks!

Norman,
My quick guess is that Project is receiving the duration data but you
don't recognize it because it is in minutes. All time based data in
Project is held in Project's underlying database in tenths of minutes.
So if you import a task with a 10 day duration (Access), it will come
across as 10 minutes in Project. However, if the default duration
(Tools/Options/Schedule tab) is set to display days in the duration
field, those 10 minutes will display as "0" days.

Try converting your Access duration data to minutes and then see how it
works.

Hope this helps.

John
Project MVP