#import csv

In the previous post, I have discussed with you the definition of CSV files and some important points about using these files on Shopify. So I suppose that you have already had a necessary background which is enough to understand the CSV files’ definition as well as their characteristic. Now we will turn to a higher stage in the process of mastering CSV file which is learning the method to import a CSV file into your Google Sheets.

New Post has been published on http://www.varindersandhu.in/2011/05/17/sql-server-import-csv-file-to-sql-table-bulk-insert/

SQL Server – Import CSV file to SQL table - Bulk-Insert

Here is an example –  Import CSV file to SQL table using Bulk-Insert

CSV file means  Comma Separated Values file.

USE testdb GO CREATE TABLE table1 ( id INT, name VARCHAR(255), address VARCHAR(255) ) GO

<!-- google_ad_client = "pub-2404605494811633"; google_alternate_color = "FFFFFF"; google_ad_width = 468; google_ad_height = 60; google_ad_format = "468x60_as"; google_ad_type = "text_image"; google_ad_channel =""; google_color_border = "FFFFFF"; google_color_link = "0000FF"; google_color_bg = "FFFFFF"; google_color_text = "000000"; google_color_url = "008000"; google_ui_features = "rc:6"; //-->

Create CSV file in Shared folder on any remote location with name csv.txt

Suppose location of the file is \\dcc-566\Share\CSV.txt

Content of CSV file as :

Now let‘s Import this CSV file into Table1.