Export of Excel 97 dates into MS Project 98 seems not workin

fred · Mar 15th, 2002, 06:49 AM

Hi again,

I try to use softs for what they are at best: Excel to manipulate dates and tasks names, MS Project to display the GANTT chart (although I used to play with conditional formatting in Excel too.

However I am at a loss to try to dump Excel dates into MS Project (using in MS Project the Open-Map from Excel file): whatever I do, MS Project considers the dates of Excel as text and not dates (I tried and checked carefully the cell format): therefore the import of data from Excel to MS Project does not work. I even tried to export dates from MS Project to Excel, and the Map keeps on saying the dates of MS Project are text field!!!

How can I overcome this? Is there any patch to use with Excel or MS Project?

Thanks for any reply

cdiffell · Mar 15th, 2002, 07:07 AM

I've used project some: have you tried copying the whole column of dates from excel and PASTING them into Project? That might work...

fred · Mar 15th, 2002, 07:10 AM

Hi,

Yes, it will work indeed, I used it. But I want to automate this (weekly updates).

Thanks anyway

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 15th, 2002, 06:49 AM	#1
fred New Member Join Date: Mar 2002 Location: Brussels Posts: 5	Hi again, I try to use softs for what they are at best: Excel to manipulate dates and tasks names, MS Project to display the GANTT chart (although I used to play with conditional formatting in Excel too. However I am at a loss to try to dump Excel dates into MS Project (using in MS Project the Open-Map from Excel file): whatever I do, MS Project considers the dates of Excel as text and not dates (I tried and checked carefully the cell format): therefore the import of data from Excel to MS Project does not work. I even tried to export dates from MS Project to Excel, and the Map keeps on saying the dates of MS Project are text field!!! How can I overcome this? Is there any patch to use with Excel or MS Project? Thanks for any reply

Mar 15th, 2002, 07:07 AM	#2
cdiffell New Member Join Date: Mar 2002 Location: Clearwater, FL Posts: 46	I've used project some: have you tried copying the whole column of dates from excel and PASTING them into Project? That might work...

Mar 15th, 2002, 07:10 AM	#3
fred New Member Join Date: Mar 2002 Location: Brussels Posts: 5	Hi, Yes, it will work indeed, I used it. But I want to automate this (weekly updates). Thanks anyway