Importing a information from a CSV into a site list

[jamie77]

I am new to Shaprepoint Services and a telecoms engineer by trade so be gentle with me!!!

I have a 2003 SBS server and I am running a Help Desk application using Sharepoint 3.

I have created a Site list that is to contain all our customer contact details.

Is there a way to import this information directly into Sharepoint or do I have to input all the information into the list by hand???? I have 200+ client details that I need in this list and don't fancy doing it by hand!!!!

Thanks in advance.

Jamie Green

ACA:Implement - IP Office
ACS:Implement - IP Office

http://www.alliedcom.co.uk

Fooball is not a matter of life and death-It is far more important!!!!

 

[MaxEd]

try pasting it as a datasheet.

-Laughter works miracles.

 

[jamie77]

Not as simple as that but got there after you pointed me in the right direction.

Thanks muchly!

Do you know of anyway of making the ID number it assigns start from something higher than one? ie 10001???

Jamie Green

ACA:Implement - IP Office
ACS:Implement - IP Office

http://www.alliedcom.co.uk

Fooball is not a matter of life and death-It is far more important!!!!

 

[jamie77]

and how to change the date format from MM/DD/YYYY to DD/MM/YYYY

Jamie Green

ACA:Implement - IP Office
ACS:Implement - IP Office

http://www.alliedcom.co.uk

Fooball is not a matter of life and death-It is far more important!!!!

 

[MaxEd]

I think that's an actual code change. I don't think there's a neat way of doing it using the gui.

-Laughter works miracles.

 

[jamie77]

Thanks for that.

I found it. It is the Web Site regional setting!!

Obvious I suppose but I thought I had done that already!!!!

Jamie Green

ACA:Implement - IP Office
ACS:Implement - IP Office

http://www.alliedcom.co.uk

Fooball is not a matter of life and death-It is far more important!!!!