Export Tab Delimited text file to sql

Question

User66564246 posted

To All,

How Can I export data from a tab delimited text file to sql?

Please note that the first row is not a header.

Data Inside my text file are:

00000001    00000000    00000000    20110708    00001115
00000002    00007510    00007146    20110708    00001115
00000003    00004714    00004198    20110708    00001115
00000004    00004260    00002995    20110708    00001115
00000005    00007403    00006510    20110708    00001115
00000006    00006467    00005106    20110708    00001115
00000007    00008647    00005988    20110708    00001115
00000008    00004327    00003903    20110708    00001115
00000009    00000000    00000000    20110708    00001115
00000010    00000000    00000000    20110708    00001115
00000011    00000000    00000000    20110708    00001115
00000012    00000000    00000000    20110708    00001115
00000013    00017579    00014960    20110708    00001115
00000014    00011552    00010194    20110708    00001115
00000015    00012333    00011436    20110708    00001115
00000016    00014907    00012437    20110708    00001115
00000017    00000969    00000638    20110708    00001115
00000018    00016949    00015716    20110708    00001115
00000019    00016430    00015413    20110708    00001115
00000020    00019718    00016442    20110708    00001115
00000021    00010305    00009771    20110708    00001115
00000022    00017235    00016937    20110708    00001115
00000023    00002643    00002378    20110708    00001115
00000024    00015245    00012859    20110708    00001115
00000025    00000021    00000006    20110708    00001115
00000026    00003026    00002016    20110708    00001115
00000027    00010969    00008859    20110708    00001115
00000028    00007921    00006838    20110708    00001115
00000029    00000000    00004927    20110708    00001115
00000030    00000000    00008120    20110708    00001115

Apologies if I'm not in the right thread.

Answer 1

User-1637433209 posted

try this

http://www.codeproject.com/KB/aspnet/ImportExportCSV.aspx

Answer 2

User3866881 posted

If necessary, I think you can use something like Comma (English input state) and save it into csv formation.

and then you can use "BulkCopy" to deal with that.

http://blog.sqlauthority.com/2008/02/06/sql-server-import-csv-file-into-sql-server-using-bulk-insert-load-comma-delimited-file-into-sql-server/