Bonjour,
J'aimerai savoir s'il est possible d'exporter un état access sur un site
Sharepoint.
Merci beaucoup
MCC
Bonjour,
J'aimerai savoir s'il est possible d'exporter un état access sur un site
Sharepoint.
Merci beaucoup
MCC
Bonjour,
J'aimerai savoir s'il est possible d'exporter un état access sur un site
Sharepoint.
Merci beaucoup
MCC
Bonjour,
Une piste, désolé pour mon 1er poste:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsmart03/html/sa03i1.aspImporting SharePoint data to AccessOf course, if you can export, you can import. Importing SharePoint data toAccess is a bit more complicated than exporting it, but still relativelystraightforward: 1.. Select File | Get External Data | Import. 2.. Select SharePoint Team Services in the Files of Type combo box (onceagain, I expect this will change for the release version). This will launchthe Import From Windows SharePoint Services Wizard. 3.. Enter the URL of the SharePoint site containing the data to import andclick Next. 4.. On the next panel of the wizard, you can choose whether to importlists or views. A view is similar to an Access query: It represents somesubset of a list (for example, "My tasks" is a view of the standard Taskslist). You can use Ctrl+Click to select multiple lists to import. 5.. You also need to select what to do about lookup columns. The check box"Retrieve IDs
Bonjour,
Une piste, désolé pour mon 1er poste:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsmart03/html/sa03i1.aspImporting SharePoint data to AccessOf course, if you can export, you can import. Importing SharePoint data toAccess is a bit more complicated than exporting it, but still relativelystraightforward: 1.. Select File | Get External Data | Import. 2.. Select SharePoint Team Services in the Files of Type combo box (onceagain, I expect this will change for the release version). This will launchthe Import From Windows SharePoint Services Wizard. 3.. Enter the URL of the SharePoint site containing the data to import andclick Next. 4.. On the next panel of the wizard, you can choose whether to importlists or views. A view is similar to an Access query: It represents somesubset of a list (for example, "My tasks" is a view of the standard Taskslist). You can use Ctrl+Click to select multiple lists to import. 5.. You also need to select what to do about lookup columns. The check box"Retrieve IDs
Bonjour,
Une piste, désolé pour mon 1er poste:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsmart03/html/sa03i1.aspImporting SharePoint data to AccessOf course, if you can export, you can import. Importing SharePoint data toAccess is a bit more complicated than exporting it, but still relativelystraightforward: 1.. Select File | Get External Data | Import. 2.. Select SharePoint Team Services in the Files of Type combo box (onceagain, I expect this will change for the release version). This will launchthe Import From Windows SharePoint Services Wizard. 3.. Enter the URL of the SharePoint site containing the data to import andclick Next. 4.. On the next panel of the wizard, you can choose whether to importlists or views. A view is similar to an Access query: It represents somesubset of a list (for example, "My tasks" is a view of the standard Taskslist). You can use Ctrl+Click to select multiple lists to import. 5.. You also need to select what to do about lookup columns. The check box"Retrieve IDs
Merci +++ pour les informations.
Je regarde.
MCC
"EROL [MVP SPS]" a écrit :
> Bonjour,
>
> Une piste, désolé pour mon 1er poste:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsmart03/html/sa03i1.aspImporting SharePoint data to AccessOf course, if you can export, you can import. Importing SharePoint data toAccess is a bit more complicated than exporting it, but still relativelystraightforward: 1.. Select File | Get External Data | Import. 2.. Select SharePoint Team Services in the Files of Type combo box (onceagain, I expect this will change for the release version). This will launchthe Import From Windows SharePoint Services Wizard. 3.. Enter the URL of the SharePoint site containing the data to import andclick Next. 4.. On the next panel of the wizard, you can choose whether to importlists or views. A view is similar to an Access query: It represents somesubset of a list (for example, "My tasks" is a view of the standard Taskslist). You can use Ctrl+Click to select multiple lists to import. 5.. You also need to select what to do about lookup columns. The check box"Retrieve IDs
for lookup columns" is somewhat confusing. If you uncheck thebox, then any lookup columns in the data are filled with data from the otherlist. For example, the Tasks list has some lookup columns that get namesfrom the UserInfo list. If you uncheck this box, then the imported Accesstable will contain the actual names, rather than the numeric IDs. If youcheck the box, the numeric IDs will be imported. 6.. If you choose to retrieve IDs, the wizard will next let you decidewhat to do about the related lists. You can choose to create linked tablespointing to those lists, or to import them to their own Access tables. 7.. The final pane of the wizard will confirm your choices. Click Finishto import the table or tables that you chose.When you import SharePoint data to Access, Access will import as many fieldproperties as it can. For example, if a SharePoint list contains a currencycolumn, the import process will create a currency field in Access. Accesswill also inherit the Required,
Default value, Format, and Decimal Placessettings from the SharePoint column (remember that it's MSDE/SQL Serverthat's storing the SharePoint data, so there's a lot of overlap with Jettables). In addition, Access will build a validation rule to enforce theminimum and maximum values set in SharePoint.Allez sur le site je l'ai refait et largement développé,voir : http://ôt sur les news de SharePoint.Bonne fin de semaine.EROL[MVP SharePoint Microsoft France]*****************************************http://www.clubsps.orghttp://aspnet2.com/mvp.ashx?ErolGiraudyhttp://sharepointerol.blogspot.com/http://giraudyp.perso.cegetel.net/Visites/Livre3.htm=============================="MCC" a écrit dans le message de news: Bonjour,> J'aimerai savoir s'il est possible d'exporter un état access sur un site> Sharepoint.> Merci beaucoup> MCC
>
>
Merci +++ pour les informations.
Je regarde.
MCC
"EROL [MVP SPS]" a écrit :
> Bonjour,
>
> Une piste, désolé pour mon 1er poste:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsmart03/html/sa03i1.aspImporting SharePoint data to AccessOf course, if you can export, you can import. Importing SharePoint data toAccess is a bit more complicated than exporting it, but still relativelystraightforward: 1.. Select File | Get External Data | Import. 2.. Select SharePoint Team Services in the Files of Type combo box (onceagain, I expect this will change for the release version). This will launchthe Import From Windows SharePoint Services Wizard. 3.. Enter the URL of the SharePoint site containing the data to import andclick Next. 4.. On the next panel of the wizard, you can choose whether to importlists or views. A view is similar to an Access query: It represents somesubset of a list (for example, "My tasks" is a view of the standard Taskslist). You can use Ctrl+Click to select multiple lists to import. 5.. You also need to select what to do about lookup columns. The check box"Retrieve IDs
for lookup columns" is somewhat confusing. If you uncheck thebox, then any lookup columns in the data are filled with data from the otherlist. For example, the Tasks list has some lookup columns that get namesfrom the UserInfo list. If you uncheck this box, then the imported Accesstable will contain the actual names, rather than the numeric IDs. If youcheck the box, the numeric IDs will be imported. 6.. If you choose to retrieve IDs, the wizard will next let you decidewhat to do about the related lists. You can choose to create linked tablespointing to those lists, or to import them to their own Access tables. 7.. The final pane of the wizard will confirm your choices. Click Finishto import the table or tables that you chose.When you import SharePoint data to Access, Access will import as many fieldproperties as it can. For example, if a SharePoint list contains a currencycolumn, the import process will create a currency field in Access. Accesswill also inherit the Required,
Default value, Format, and Decimal Placessettings from the SharePoint column (remember that it's MSDE/SQL Serverthat's storing the SharePoint data, so there's a lot of overlap with Jettables). In addition, Access will build a validation rule to enforce theminimum and maximum values set in SharePoint.Allez sur le site je l'ai refait et largement développé,voir : http://www.mysps.info@bientôt sur les news de SharePoint.Bonne fin de semaine.EROL[MVP SharePoint Microsoft France]*****************************************http://www.clubsps.orghttp://aspnet2.com/mvp.ashx?ErolGiraudyhttp://sharepointerol.blogspot.com/http://giraudyp.perso.cegetel.net/Visites/Livre3.htm=============================="MCC" <MCC@discussions.microsoft.com> a écrit dans le message de news:283AA07E-A22E-41B8-AC69-5ABECB71FD83@microsoft.com...> Bonjour,> J'aimerai savoir s'il est possible d'exporter un état access sur un site> Sharepoint.> Merci beaucoup> MCC
>
>
Merci +++ pour les informations.
Je regarde.
MCC
"EROL [MVP SPS]" a écrit :
> Bonjour,
>
> Une piste, désolé pour mon 1er poste:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsmart03/html/sa03i1.aspImporting SharePoint data to AccessOf course, if you can export, you can import. Importing SharePoint data toAccess is a bit more complicated than exporting it, but still relativelystraightforward: 1.. Select File | Get External Data | Import. 2.. Select SharePoint Team Services in the Files of Type combo box (onceagain, I expect this will change for the release version). This will launchthe Import From Windows SharePoint Services Wizard. 3.. Enter the URL of the SharePoint site containing the data to import andclick Next. 4.. On the next panel of the wizard, you can choose whether to importlists or views. A view is similar to an Access query: It represents somesubset of a list (for example, "My tasks" is a view of the standard Taskslist). You can use Ctrl+Click to select multiple lists to import. 5.. You also need to select what to do about lookup columns. The check box"Retrieve IDs
for lookup columns" is somewhat confusing. If you uncheck thebox, then any lookup columns in the data are filled with data from the otherlist. For example, the Tasks list has some lookup columns that get namesfrom the UserInfo list. If you uncheck this box, then the imported Accesstable will contain the actual names, rather than the numeric IDs. If youcheck the box, the numeric IDs will be imported. 6.. If you choose to retrieve IDs, the wizard will next let you decidewhat to do about the related lists. You can choose to create linked tablespointing to those lists, or to import them to their own Access tables. 7.. The final pane of the wizard will confirm your choices. Click Finishto import the table or tables that you chose.When you import SharePoint data to Access, Access will import as many fieldproperties as it can. For example, if a SharePoint list contains a currencycolumn, the import process will create a currency field in Access. Accesswill also inherit the Required,
Default value, Format, and Decimal Placessettings from the SharePoint column (remember that it's MSDE/SQL Serverthat's storing the SharePoint data, so there's a lot of overlap with Jettables). In addition, Access will build a validation rule to enforce theminimum and maximum values set in SharePoint.Allez sur le site je l'ai refait et largement développé,voir : http://ôt sur les news de SharePoint.Bonne fin de semaine.EROL[MVP SharePoint Microsoft France]*****************************************http://www.clubsps.orghttp://aspnet2.com/mvp.ashx?ErolGiraudyhttp://sharepointerol.blogspot.com/http://giraudyp.perso.cegetel.net/Visites/Livre3.htm=============================="MCC" a écrit dans le message de news: Bonjour,> J'aimerai savoir s'il est possible d'exporter un état access sur un site> Sharepoint.> Merci beaucoup> MCC
>
>
Je cherchais à importer des états access et non des tables.
Finalement, j'ai exporté les états au format snp sur un site sharepoint.
Encore merci pour votre temps.
MCC
"MCC" a écrit :Merci +++ pour les informations.
Je regarde.
MCC
"EROL [MVP SPS]" a écrit :
> Bonjour,
>
> Une piste, désolé pour mon 1er poste:
>
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsmart03/html/sa03i1.aspImporting
> SharePoint data to AccessOf course, if you can export, you can import.
> Importing SharePoint data toAccess is a bit more complicated than
> exporting it, but still relativelystraightforward: 1.. Select File |
> Get External Data | Import. 2.. Select SharePoint Team Services in the
> Files of Type combo box (onceagain, I expect this will change for the
> release version). This will launchthe Import From Windows SharePoint
> Services Wizard. 3.. Enter the URL of the SharePoint site containing
> the data to import andclick Next. 4.. On the next panel of the wizard,
> you can choose whether to importlists or views. A view is similar to an
> Access query: It represents somesubset of a list (for example, "My
> tasks" is a view of the standard Taskslist). You can use Ctrl+Click to
> select multiple lists to import. 5.. You also need to select what to
> do about lookup columns. The check box"Retrieve IDs
for lookup columns" is somewhat confusing. If you uncheck thebox, then
any lookup columns in the data are filled with data from the otherlist.
For example, the Tasks list has some lookup columns that get namesfrom
the UserInfo list. If you uncheck this box, then the imported Accesstable
will contain the actual names, rather than the numeric IDs. If youcheck
the box, the numeric IDs will be imported. 6.. If you choose to retrieve
IDs, the wizard will next let you decidewhat to do about the related
lists. You can choose to create linked tablespointing to those lists, or
to import them to their own Access tables. 7.. The final pane of the
wizard will confirm your choices. Click Finishto import the table or
tables that you chose.When you import SharePoint data to Access, Access
will import as many fieldproperties as it can. For example, if a
SharePoint list contains a currencycolumn, the import process will create
a currency field in Access. Accesswill also inherit the Required,
Default value, Format, and Decimal Placessettings from the SharePoint
column (remember that it's MSDE/SQL Serverthat's storing the SharePoint
data, so there's a lot of overlap with Jettables). In addition, Access
will build a validation rule to enforce theminimum and maximum values set
in SharePoint.Allez sur le site je l'ai refait et largement
développé,voir : http://ôt sur les news de
SharePoint.Bonne fin de semaine.EROL[MVP SharePoint Microsoft
France]*****************************************http://www.clubsps.orghttp://aspnet2.com/mvp.ashx?ErolGiraudyhttp://sharepointerol.blogspot.com/http://giraudyp.perso.cegetel.net/Visites/Livre3.htm=============================="MCC"
a écrit dans le message de
news: Bonjour,>
J'aimerai savoir s'il est possible d'exporter un état access sur un site>
Sharepoint.> Merci beaucoup> MCC
>
>
Je cherchais à importer des états access et non des tables.
Finalement, j'ai exporté les états au format snp sur un site sharepoint.
Encore merci pour votre temps.
MCC
"MCC" a écrit :
Merci +++ pour les informations.
Je regarde.
MCC
"EROL [MVP SPS]" a écrit :
> Bonjour,
>
> Une piste, désolé pour mon 1er poste:
>
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsmart03/html/sa03i1.aspImporting
> SharePoint data to AccessOf course, if you can export, you can import.
> Importing SharePoint data toAccess is a bit more complicated than
> exporting it, but still relativelystraightforward: 1.. Select File |
> Get External Data | Import. 2.. Select SharePoint Team Services in the
> Files of Type combo box (onceagain, I expect this will change for the
> release version). This will launchthe Import From Windows SharePoint
> Services Wizard. 3.. Enter the URL of the SharePoint site containing
> the data to import andclick Next. 4.. On the next panel of the wizard,
> you can choose whether to importlists or views. A view is similar to an
> Access query: It represents somesubset of a list (for example, "My
> tasks" is a view of the standard Taskslist). You can use Ctrl+Click to
> select multiple lists to import. 5.. You also need to select what to
> do about lookup columns. The check box"Retrieve IDs
for lookup columns" is somewhat confusing. If you uncheck thebox, then
any lookup columns in the data are filled with data from the otherlist.
For example, the Tasks list has some lookup columns that get namesfrom
the UserInfo list. If you uncheck this box, then the imported Accesstable
will contain the actual names, rather than the numeric IDs. If youcheck
the box, the numeric IDs will be imported. 6.. If you choose to retrieve
IDs, the wizard will next let you decidewhat to do about the related
lists. You can choose to create linked tablespointing to those lists, or
to import them to their own Access tables. 7.. The final pane of the
wizard will confirm your choices. Click Finishto import the table or
tables that you chose.When you import SharePoint data to Access, Access
will import as many fieldproperties as it can. For example, if a
SharePoint list contains a currencycolumn, the import process will create
a currency field in Access. Accesswill also inherit the Required,
Default value, Format, and Decimal Placessettings from the SharePoint
column (remember that it's MSDE/SQL Serverthat's storing the SharePoint
data, so there's a lot of overlap with Jettables). In addition, Access
will build a validation rule to enforce theminimum and maximum values set
in SharePoint.Allez sur le site je l'ai refait et largement
développé,voir : http://www.mysps.info@bientôt sur les news de
SharePoint.Bonne fin de semaine.EROL[MVP SharePoint Microsoft
France]*****************************************http://www.clubsps.orghttp://aspnet2.com/mvp.ashx?ErolGiraudyhttp://sharepointerol.blogspot.com/http://giraudyp.perso.cegetel.net/Visites/Livre3.htm=============================="MCC"
<MCC@discussions.microsoft.com> a écrit dans le message de
news:283AA07E-A22E-41B8-AC69-5ABECB71FD83@microsoft.com...> Bonjour,>
J'aimerai savoir s'il est possible d'exporter un état access sur un site>
Sharepoint.> Merci beaucoup> MCC
>
>
Je cherchais à importer des états access et non des tables.
Finalement, j'ai exporté les états au format snp sur un site sharepoint.
Encore merci pour votre temps.
MCC
"MCC" a écrit :Merci +++ pour les informations.
Je regarde.
MCC
"EROL [MVP SPS]" a écrit :
> Bonjour,
>
> Une piste, désolé pour mon 1er poste:
>
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsmart03/html/sa03i1.aspImporting
> SharePoint data to AccessOf course, if you can export, you can import.
> Importing SharePoint data toAccess is a bit more complicated than
> exporting it, but still relativelystraightforward: 1.. Select File |
> Get External Data | Import. 2.. Select SharePoint Team Services in the
> Files of Type combo box (onceagain, I expect this will change for the
> release version). This will launchthe Import From Windows SharePoint
> Services Wizard. 3.. Enter the URL of the SharePoint site containing
> the data to import andclick Next. 4.. On the next panel of the wizard,
> you can choose whether to importlists or views. A view is similar to an
> Access query: It represents somesubset of a list (for example, "My
> tasks" is a view of the standard Taskslist). You can use Ctrl+Click to
> select multiple lists to import. 5.. You also need to select what to
> do about lookup columns. The check box"Retrieve IDs
for lookup columns" is somewhat confusing. If you uncheck thebox, then
any lookup columns in the data are filled with data from the otherlist.
For example, the Tasks list has some lookup columns that get namesfrom
the UserInfo list. If you uncheck this box, then the imported Accesstable
will contain the actual names, rather than the numeric IDs. If youcheck
the box, the numeric IDs will be imported. 6.. If you choose to retrieve
IDs, the wizard will next let you decidewhat to do about the related
lists. You can choose to create linked tablespointing to those lists, or
to import them to their own Access tables. 7.. The final pane of the
wizard will confirm your choices. Click Finishto import the table or
tables that you chose.When you import SharePoint data to Access, Access
will import as many fieldproperties as it can. For example, if a
SharePoint list contains a currencycolumn, the import process will create
a currency field in Access. Accesswill also inherit the Required,
Default value, Format, and Decimal Placessettings from the SharePoint
column (remember that it's MSDE/SQL Serverthat's storing the SharePoint
data, so there's a lot of overlap with Jettables). In addition, Access
will build a validation rule to enforce theminimum and maximum values set
in SharePoint.Allez sur le site je l'ai refait et largement
développé,voir : http://ôt sur les news de
SharePoint.Bonne fin de semaine.EROL[MVP SharePoint Microsoft
France]*****************************************http://www.clubsps.orghttp://aspnet2.com/mvp.ashx?ErolGiraudyhttp://sharepointerol.blogspot.com/http://giraudyp.perso.cegetel.net/Visites/Livre3.htm=============================="MCC"
a écrit dans le message de
news: Bonjour,>
J'aimerai savoir s'il est possible d'exporter un état access sur un site>
Sharepoint.> Merci beaucoup> MCC
>
>
