Calling Sql Experts

[samajaaragamana]

CSV file try chesthe em osthundi uncle??

[tables]

extra lines unnaya? or extra dots?

[RangeRover]

aa excel file is more than 200MB undi man.. open ayi savatley... laptop freeze ayithundi _%~ _%~

CSV Split SWs mast untaau ga google lo.. break da file by lines and Trim and insert into SQL..

 

https://sourceforge.net/projects/splitcsv/

http://www.makeuseof.com/tag/how-to-split-a-huge-csv-excel-workbook-into-seperate-files/

[RangeRover]

extra lines unnaya? or extra dots?

looks like empty spaces @Columns..

[RangeRover]

Yes ee rendu vadachu all you will do is in excel so title excel experts ani pettu ostharu...inkonthamandi..............Sql daka avasarma ledhu

basha kanna bhavam mukhyam.. title kanna pani avvadam mukhyam

[RangeRover]

CSV file try chesthe em osthundi uncle??

scrooge loose avtundhi anta

[samajaaragamana]

basha kanna bhavam mukhyam.. title kanna pani avvadam mukhyam

Inkontha mandi osthe pani avudhi ani ala petta uncle............as u drive i say nu ela ante ala

[tables]

if there are unwanted dots, then use SSIS , REPLACE function and replace them with empty string.

[manjunath455]

if there are unwanted dots, then use SSIS , REPLACE function and replace them with empty string.

+1 

[samajaaragamana]

if there are unwanted dots, then use SSIS , REPLACE function and replace them with empty string.

+1 

[nenu_devudni]

Replace use seye uncle to remove an special
Characters in the field .. Nen bi recent ga sesa util file Vadi

[150bryant]

entha undhi csv file?

size

[Kakateyudu]

notepad ++ lo aa  file location petti aa spaces replace chesi chudu baa

[loveindia]

if there are unwanted dots, then use SSIS , REPLACE function and replace them with empty string.

to use ssis replace function which is a transformation, he should be able to use it via flat file source nooo man.. he is sayina truncation is happening... which will fail in flat file extraction itself which is the first step...

Screw loose man, what is the delimiter for the file (comma) , if so can your data also have a comma?? By default sql gives 50 characters string.. change it to 8000 and see, if that doesn't work I believe we should use a c# script which will make it work without any issues man..

[loveindia]

entha undhi csv file?
size

200 MB annadu ga man..