how to import a zip ascii file in MS SQL server?

Question

My file if unzip is very large (more than 1GB). So if I want to load the zip file (in .asc format) in MS SQL server, how can I do that? Thanks!

Answer 1

you want the entire file to be in one record of a table, use a BLOB!

you want to parse it out and create many different records with seperate fields, unzip the file, and convert it to one of the many formats(tab delimited or sql inserts or others) that can be used to import in mysql.

Answer 2

in accordance to the question on importing the Excel 2007 files to sq. Server 2005, i'd opt for to furnish you the techniques as follows: a million. Connection string difficulty: Please verify if you're prepared to connect both Excel 2007 and sq. Server 2005 because the files source effectively. The excelConnection looks locate as you provided. then you fairly could also upload "HDR=certain" to teach that the first row contains columnnames, no longer files. "HDR=No;" shows the different. this would circumvent the first row wondered at the same time as importing to the sq. tables. 2. Please try your ODBC sq. Server connection string in order that the relationship to sq. Server is ideal. except the ODBC, you could also use SqlConnection and execute the SqlCommand merchandise with the reality that contains the excelConnection on your VB.internet code, yet no longer only combine the total in a unmarried sq. reality. proper right here article shows you the way: Import Excel sheet into table 3. except the above techniques, you could evaluate to apply SqlBulkCopy classification to import. proper right here article shows you the social gathering: Import Excel Spreadsheet files into sq. Server Database table utilizing SqlBulkCopy 4. there's a KB article in MSDN on the issue. besides the actual shown reality that the object isn't utilized for sq. Server 2005, you could also learn on sq. Server files Transformation amenities (DTS), Microsoft sq. Server 2005 Integration amenities (SSIS), sq. Server linked servers and sq. Server dispensed queries. they are effective on your artwork. a thanks to import files from Excel to sq. Server wish that would help you.

Answer 3

Big file ... maybe you should forget keeping it in db and just do the addressing to the zip file in your database ...

Answer 4

I don't believe you can.