I will be publishing (not linked) an "excel table" to a "sharepoint list".

I am using a listobject that I load with the excel table and use the publish
from the list object.

I need to set field types in excel so that when the data gets to sharepoint
it is correct, one example is it currently pushes as a 'single line of text'
and I need the field to be 'multiple lines of text'. It would be nice if I
could push "multiple choice" fields too.

Is there a way I can set the field type of the list object fields before I
publish it? I have searched the internet several hours two times now.
Looking for specific VBA code. Using Office 2007 and SharePoint 2007
(project at MS).

How about suggestions where to look for help?

"Phil" wrote:

I will be publishing (not linked) an "excel table" to a "sharepoint list".

I am using a listobject that I load with the excel table and use the publish
from the list object.

I need to set field types in excel so that when the data gets to sharepoint
it is correct, one example is it currently pushes as a 'single line of text'
and I need the field to be 'multiple lines of text'. It would be nice if I
could push "multiple choice" fields too.

Is there a way I can set the field type of the list object fields before I
publish it? I have searched the internet several hours two times now.
Looking for specific VBA code. Using Office 2007 and SharePoint 2007
(project at MS).

Any help is appreciated... really stuck here.

"Phil" wrote:

I will be publishing (not linked) an "excel table" to a "sharepoint list".

I am using a listobject that I load with the excel table and use the publish
from the list object.

I need to set field types in excel so that when the data gets to sharepoint
it is correct, one example is it currently pushes as a 'single line of text'
and I need the field to be 'multiple lines of text'. It would be nice if I
could push "multiple choice" fields too.

Is there a way I can set the field type of the list object fields before I
publish it? I have searched the internet several hours two times now.
Looking for specific VBA code. Using Office 2007 and SharePoint 2007
(project at MS).

Did you have any luck with this in the end?

I'm having the same issues.

Mark

On Monday, July 07, 2008 3:01 PM Phi wrote:

I will be publishing (not linked) an "excel table" to a "sharepoint list".

I am using a listobject that I load with the excel table and use the publish
from the list object.

I need to set field types in excel so that when the data gets to sharepoint
it is correct, one example is it currently pushes as a 'single line of text'
and I need the field to be 'multiple lines of text'. It would be nice if I
could push "multiple choice" fields too.

Is there a way I can set the field type of the list object fields before I
publish it? I have searched the internet several hours two times now.
Looking for specific VBA code. Using Office 2007 and SharePoint 2007
(project at MS).


On Tuesday, July 08, 2008 11:13 AM Phi wrote:

How about suggestions where to look for help?

"Phil" wrote:


On Tuesday, July 08, 2008 1:32 PM Phi wrote:

Any help is appreciated... really stuck here.

"Phil" wrote: