RE: .asc file to .txt file – SQLServerCentral

SSC Guru

Points: 323506

March 16, 2012 at 2:56 pm

ramchandra2cool (3/16/2012)
when i did that i got junk characters there . can u pls advise

ALL junk characters or SOME junk characters? was it human readable when you opened it?

if all junk characters, you better check with the source you got the data from then; asc is short for ASCII, which imples plain old ascii text files.

if it's another file type that happens to be renamed with a misleading extension , you'll have to track the files from their source.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!