I have an excel file with contact data for customers. Now I want to import it
into CRM 3.0. I use the guide but I am stuck at the manual import i.e.
populate CDF at step 5 in the data migration framework application. Do I have
to go to the SQL server and select the database and import into the contacts
table?

I am really sorry for the newbie question..

/Jonas

RE: Importing data from an excel file by RonaldL

RonaldL
Tue Feb 06 05:09:00 CST 2007

Hi Jonas,

You will indeed need to populate the CDF tables. You can do this via several
ways of which using SSIS is my personal favorite.

Hope this helps,
--
Ronald Lemmen - MSCRM MVP
Avanade Netherlands
http://ronaldlemmen.blogspot.com/


"Jonas Persson" wrote:

> I have an excel file with contact data for customers. Now I want to import it
> into CRM 3.0. I use the guide but I am stuck at the manual import i.e.
> populate CDF at step 5 in the data migration framework application. Do I have
> to go to the SQL server and select the database and import into the contacts
> table?
>
> I am really sorry for the newbie question..
>
> /Jonas

RE: Importing data from an excel file by JonasPersson

JonasPersson
Tue Feb 06 05:11:01 CST 2007

Thank you Ronald

What i SSIS?

/Jonas

"Ronald Lemmen" wrote:

> Hi Jonas,
>
> You will indeed need to populate the CDF tables. You can do this via several
> ways of which using SSIS is my personal favorite.
>
> Hope this helps,
> --
> Ronald Lemmen - MSCRM MVP
> Avanade Netherlands
> http://ronaldlemmen.blogspot.com/
>
>
> "Jonas Persson" wrote:
>
> > I have an excel file with contact data for customers. Now I want to import it
> > into CRM 3.0. I use the guide but I am stuck at the manual import i.e.
> > populate CDF at step 5 in the data migration framework application. Do I have
> > to go to the SQL server and select the database and import into the contacts
> > table?
> >
> > I am really sorry for the newbie question..
> >
> > /Jonas

RE: Importing data from an excel file by RonaldL

RonaldL
Tue Feb 06 05:54:01 CST 2007

Jonas,

SSIS is Microsoft SQL Server Integration Services. This is an ETL (Extract,
Transform, Load) application and part of Visual Studio and SQL Server 2005.
You can use this to insert the data from an excel file into the CDF tables of
the data migration framework. You will need knowledge of SSIS ofcourse before
you could use it..

Hope this helps,
--
Ronald Lemmen - MSCRM MVP
Avanade Netherlands
http://ronaldlemmen.blogspot.com/


"Jonas Persson" wrote:

> Thank you Ronald
>
> What i SSIS?
>
> /Jonas
>
> "Ronald Lemmen" wrote:
>
> > Hi Jonas,
> >
> > You will indeed need to populate the CDF tables. You can do this via several
> > ways of which using SSIS is my personal favorite.
> >
> > Hope this helps,
> > --
> > Ronald Lemmen - MSCRM MVP
> > Avanade Netherlands
> > http://ronaldlemmen.blogspot.com/
> >
> >
> > "Jonas Persson" wrote:
> >
> > > I have an excel file with contact data for customers. Now I want to import it
> > > into CRM 3.0. I use the guide but I am stuck at the manual import i.e.
> > > populate CDF at step 5 in the data migration framework application. Do I have
> > > to go to the SQL server and select the database and import into the contacts
> > > table?
> > >
> > > I am really sorry for the newbie question..
> > >
> > > /Jonas

RE: Importing data from an excel file by JonasPersson

JonasPersson
Tue Feb 06 08:31:00 CST 2007

Thanks

"Ronald Lemmen" wrote:

> Jonas,
>
> SSIS is Microsoft SQL Server Integration Services. This is an ETL (Extract,
> Transform, Load) application and part of Visual Studio and SQL Server 2005.
> You can use this to insert the data from an excel file into the CDF tables of
> the data migration framework. You will need knowledge of SSIS ofcourse before
> you could use it..
>
> Hope this helps,
> --
> Ronald Lemmen - MSCRM MVP
> Avanade Netherlands
> http://ronaldlemmen.blogspot.com/
>
>
> "Jonas Persson" wrote:
>
> > Thank you Ronald
> >
> > What i SSIS?
> >
> > /Jonas
> >
> > "Ronald Lemmen" wrote:
> >
> > > Hi Jonas,
> > >
> > > You will indeed need to populate the CDF tables. You can do this via several
> > > ways of which using SSIS is my personal favorite.
> > >
> > > Hope this helps,
> > > --
> > > Ronald Lemmen - MSCRM MVP
> > > Avanade Netherlands
> > > http://ronaldlemmen.blogspot.com/
> > >
> > >
> > > "Jonas Persson" wrote:
> > >
> > > > I have an excel file with contact data for customers. Now I want to import it
> > > > into CRM 3.0. I use the guide but I am stuck at the manual import i.e.
> > > > populate CDF at step 5 in the data migration framework application. Do I have
> > > > to go to the SQL server and select the database and import into the contacts
> > > > table?
> > > >
> > > > I am really sorry for the newbie question..
> > > >
> > > > /Jonas