hi,

i found the link below where you can download a CSV file of countries.

http://www.floresense.com/resc_center/?art=1360

 Now i dont know how to actually create the table in my database which is sql express 2005.

I have management studio express and have attached a database named MasterDB. I want the country table to

go in there. Do i click on tables and insert new query?. where would I get the query for this?

I am also using visual web developer and coding in c sharp

advice appreicated!

Instead of using BULK INSERT for this CSV file, you can import the file into an Access database first and from your management studio, you can import the table to your "MasterDB".

Hi,amereto2k

amereto2k:

i found the link below where you can download a CSV file of countries.

http://www.floresense.com/resc_center/?art=1360

from ur specified article download that csv file open it and then remove first row from that

where all columns are written .

Now save that file  in ur C:\  with name countrylist and close it .

ie ur path shuld be like that c:\countrylist.csv

Now in sql write

U will get the all data in ur country table.

PLZ MARK AS ANSWER IF IT HELP U.

THANKS.

Hi, I tryed that but got the following

basically, after deleting row and saving file,  I went to my database in management studion clicked on tables and then insert new query.

I pasted your code in and hit execute? any reason you know it failed.

Also Can I just ask to which is the primary key because I will wont to run queries against this table with inner joins etc.

thanks

amereto

In the SQL Server 2005 Developer's edition, you right click on the database name, then click on tasks, then on import.  That will import to a table created based on the select query.  Doesn't Express have that feature?  If not, you might want to think about upgrading to the developer's edition.  Bulk insert will work as well, or you could just roll you own import program in c#, but that seems pretty much unnecessary.

Hi,amereto2k

Have u tried my code from begining that also created table from that

or u have table exist before if that

Then Plz Post ur create table script

U r saying that

amereto2k:

Msg 4864, Level 16, State 1, Line 2

Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 1 (Sort Order).

That Code is running correctly at my side .

I have checked after deleting first row from csv file.

So plz post ur table script.

Thanks.

I went to the database and in Tasks there is no import option -  just the below. I may be able to get developer version later but for

now I just want to get this country table to my existing database so I  begin running test queries against for my pilot project.

detatch

shrink

backup

Restore

Generate scripts

hi,

I deleted  [Sort Order] int , from the query and now it worked.

Sort order does show in the created table so I guess its ok right?

rgds

Hi,amereto2k

Please Mark The Post As Answer as It Gains U one Point and Help Others To Solve Their Problems

(It Is at the right top corner of every post with name 'Mark As Answer')

Thanks.