I have a *.xls file having 17 different columns. I want to convert it to a table in a database of sql server 2000. How can i do it? Please tell me steps i have to take for it..
2006-12-04 16:50:35 · 3 answers · asked by Varun S 1 in Computers & Internet ➔ Programming & Design
Yes you can do that. Use DTS to import the data from XLS it has an option to create the table and the colums.
DTS it's the way to fly...
2006-12-04 16:54:41 · answer #1 · answered by Marshall Lee 4 · 0⤊ 0⤋
in accordance to the question on uploading the Excel 2007 archives to sq. Server 2005, i might p.c. to furnish you the innovations as follows: a million. Connection string situation: Please verify in case you would be able to desire to connect the two Excel 2007 and sq. Server 2005 by way of fact the innovations source efficiently. The excelConnection seems to be locate as you provided. then you definitely could additionally upload "HDR=particular" to show that the 1st row includes columnnames, no longer archives. "HDR=No;" shows the alternative. this would steer away from the 1st row at a loss for words while uploading to the sq. tables. 2. Please attempt your ODBC sq. Server connection string in order that the relationship to sq. Server is right. different than the ODBC, you additionally can use SqlConnection and execute the SqlCommand merchandise with the undeniable fact that incorporates the excelConnection on your VB.internet code, yet no longer only combine the entire in one sq. fact. here article shows you the way: Import Excel sheet into table 3. different than the above tactics, you may planned to apply SqlBulkCopy classification to import. here article shows you the occasion: Import Excel Spreadsheet archives into sq. Server Database table employing SqlBulkCopy 4. there's a KB article in MSDN on the subject count. even with the undeniable fact that the article isn't utilized for sq. Server 2005, you additionally can learn on sq. Server archives Transformation centers (DTS), Microsoft sq. Server 2005 Integration centers (SSIS), sq. Server proper servers and sq. Server distributed queries. they're efficient on your paintings. the thank you to import archives from Excel to sq. Server desire which could help you.
2016-10-14 01:06:31 · answer #2 · answered by ? 4 · 0⤊ 0⤋
No I don't think you can do that. Hope this helps.
2006-12-04 16:52:58 · answer #3 · answered by WELL R.S. 1 · 0⤊ 0⤋