Using Access to autofill a Gantt chart

[llindaman]

Hi everyone,



I'm new here and also very new to Access. I'm starting project at work which involves creating a Project Management Schedule (Gantt chart) from an Excel spreadsheet that was exported from accounting program. I want to be able to easily update the data in the Access database using the spreadsheet export so that it will auto-fill my Gantt chart template in Excel. My issue with this is that the Excel export is in a horrible format that must be organized (i.e. some columns have two different types of information in the same column) before it can be effectively used to auto-fill the Gantt chart.

My question is, what is the best way to organize this information using Access so that I can easily link it with the Gantt chart in Excel? Should I use a macro, report, or query?

Thanks

[June7]

If the data is in Excel workbook, why is Access involved? If data is imported to Access, why involve Excel in building Gantt chart?

Review https://www.accessforums.net/databas...ses-18459.html

[llindaman]

I have a Gantt chart template in Excel. However, I was unaware that Gantt charts could be generated with Access. However my main problem is that format of the worksheet is very unorganized and it seems like I would need to somehow manipulate the data using queries or macros so it can be easily put into a Gantt chart.

[rpeare]

How about a sample of the spreadsheet as it is and what you want it to be?