How can I import a CSV file to sql server for my webpage?!?

Question

The csv file and my php files are on same host and same folder.

Answer 1

The easiest way to get a CSV file into SQL Server is to use DTS(2000) or SSIS (2005) jobs.



BCP is an alternative option, but not nearly as easy depending on the format of the data.

Answer 2

Use the SQL Enterprise Manager. Or, if you are doing it through http, the SQL Web Console.



Another easy way is if you have Access. you could import it to Access and then import it to SQL. That is probably the easiest, or should I say, most painless, way to do it.

Answer 3

in accordance to the question on importing the Excel 2007 information to sq. Server 2005, i might choose to grant you the recommendations as follows: a million. Connection string difficulty: Please examine in case you may connect the two Excel 2007 and sq. Server 2005 as a results of fact the information source efficiently. The excelConnection seems to be locate as you presented. then you definitely could additionally upload "HDR=specific" to point out that the 1st row is composed of columnnames, not information. "HDR=No;" shows the different. this might evade the 1st row puzzled whilst importing to the sq. tables. 2. Please try your ODBC sq. Server connection string in simple terms so the relationship to sq. Server is real. different than the ODBC, you additionally can use SqlConnection and execute the SqlCommand merchandise with the incontrovertible fact that contains the excelConnection on your VB.internet code, yet not in elementary terms combine the completed in one sq. fact. in this text shows you the way: Import Excel sheet into table 3. different than the above techniques, you may planned to apply SqlBulkCopy type to import. in this text shows you the example: Import Excel Spreadsheet information into sq. Server Database table utilising SqlBulkCopy 4. there's a KB article in MSDN on the subject rely. despite if the object isn't utilized for sq. Server 2005, you additionally can learn on sq. Server information Transformation centers (DTS), Microsoft sq. Server 2005 Integration centers (SSIS), sq. Server proper servers and sq. Server allotted queries. they are powerful on your artwork. a thank you to import information from Excel to sq. Server desire which could help you.

Answer 4

cvs is a version control tool u have to install it on the serve on which u wont the toll to work the add all the related files and folder on the cvs to keep track of it