Importing from MS Access


Creating a schedule by pasting Access data

Are you looking for a fast way to get Information from an Access table into Milestones, Professional to generate a schedule?

STEP 1: Copy columns from your Access table to the clipboard

1	Click and drag across the column indicators to highlight the columns you want to copy.
2	Choose Copy from the Edit menu.

STEP 2: Paste the columns into your Milestones Professional schedule

1	In Milestones Professional, select the arrow tool from the toolbox.
2	Move the cursor into the column heading area just above the line that divides the column heading and the task lines.
3	When the column selection cursor appears, click once to select the column.
4	Select Paste Column Text from the Edit menu.
5	Select Use Custom Import if more than one Access field is to be imported.

	You will see a screen similar to the following:

1	Map the fields as shown above. Map Field 1 to Column 10 (The columns are numbered 1-10 on the left side of the schedule, with Column 10 being closest to the schedule. If your schedule only has one column, it is Column 10). Map the Start Date (Field 2) to Task_1_Start_Date. Map the end date to Task_1_End_Date.
2	Type in a name in the field above to name the filter. (On the example screen, the filter is called MyFilter)
3	Press Continue Import Using Current Filter. When asked if you want to save the filter, be sure to say yes.

You should now see a schedule similar to the following:

It is possible to create different Milestones schedules based on different filtering selections by setting up different Milestones import filters. Just create each new filter by mapping to the appropriate fields in the table and saving under a unique filter name!

Interested in automating your schedule production using an Access Visual Basic macro? Click here for the Milestones Professional Programmer's page.

KIDASA Software, Inc. Website

Creating a schedule by pasting Access data

STEP 1: Copy columns from your Access table to the clipboard

STEP 2: Paste the columns into your Milestones Professional schedule