import csv - xls
-
Hi, I have a Microsoft Office Excel Comma Separated Values File (.csv)with 200,000 number of rows in excel. I want to import this to SQL 2008 database. There is a option to import in SQL but no option to import .csv file. So what would be the best way to import this file. I have created a table with correct column name, next thing i wanna do is to import all the data. I have tried below query, but no luck so far...
BULK INSERT abc_table FROM 'C:\xyz303.csv' WITH ( FIELDTERMINATOR = ',' ) GO
Thanks -
Hi, I have a Microsoft Office Excel Comma Separated Values File (.csv)with 200,000 number of rows in excel. I want to import this to SQL 2008 database. There is a option to import in SQL but no option to import .csv file. So what would be the best way to import this file. I have created a table with correct column name, next thing i wanna do is to import all the data. I have tried below query, but no luck so far...
BULK INSERT abc_table FROM 'C:\xyz303.csv' WITH ( FIELDTERMINATOR = ',' ) GO
Thanks -
Hi, I have a Microsoft Office Excel Comma Separated Values File (.csv)with 200,000 number of rows in excel. I want to import this to SQL 2008 database. There is a option to import in SQL but no option to import .csv file. So what would be the best way to import this file. I have created a table with correct column name, next thing i wanna do is to import all the data. I have tried below query, but no luck so far...
BULK INSERT abc_table FROM 'C:\xyz303.csv' WITH ( FIELDTERMINATOR = ',' ) GO
ThanksI do not have SQLServer 2008 installed, but I do have SQLServer 2005. Did you see an option for a flat file source? You should be able to import it using that. Tim