To import a text file as a table to SQL

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Sean Lange SSC Guru Points: 286590 More actions · Answer 1

right click the database -> Tasks -> Import Data.

From the data source select flat file and check the box that says the first row contains column names.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

hbanerje SSC Eights! Points: 818 More actions · Answer 2

I did that, but still having the " " for the three cols, is there any way I could omit them while importing data to a table?

Thanx

Sean Lange SSC Guru Points: 286590 More actions · Answer 3

Well those characters are in your data. If you want to remove just update your table after your import.

Update MyNewTable

set DRG_FINAL = replace(DRG_FINAL, '"', ''),

PAYOR = replace(PAYOR, '"', ''),

DISCH_SERVICE = replace(DISCH_SERVICE, '"', '')

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

hbanerje SSC Eights! Points: 818 More actions · Answer 4

SSC Eights!

Points: 818

November 1, 2011 at 2:10 pm

Thanks.

Ant-Green SSC Guru Points: 113507 More actions · Answer 5

on the flat file source, specify " as a text qualifier to have SQL strip out the " on the import