read notepad file in sql server 2005

Question

read notepad file in sql server 2005

pankaj.kuchaliya

SSC Eights!

Points: 944
More actions
September 1, 2010 at 5:43 am

#237504

Hi,
i have attached notepad file. i have one problem , how can i read the notepad file in sql server 2005.
Please reply.

Viewing 4 posts - 1 through 3 (of 3 total)

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

irobertson Hall of Fame Points: 3695 More actions · Answer 1

Hi Grasshopper,

You're going to struggle to work with the file in the format it's in. SQL needs your data to be organised into discrete entities with rows and columns. Your file is organised with data on alternate rows and has metadata embedded within the data structure itself.

If it was me, I'd write a VB script to process the data first. But then, I'm a bit old fashioned 🙂

Regards, Iain

steve-893342 SSCarpal Tunnel Points: 4439 More actions · Answer 2

Does this help you?

SELECT BulkColumn FROM OPENROWSET (BULK 'C:\test.txt', SINGLE_CLOB) AS Z

pankaj.kuchaliya SSC Eights! Points: 944 More actions · Answer 3

irobertson (9/1/2010)
Hi Grasshopper,
You're going to struggle to work with the file in the format it's in. SQL needs your data to be organised into discrete entities with rows and columns. Your file is organised with data on alternate rows and has metadata embedded within the data structure itself.
If it was me, I'd write a VB script to process the data first. But then, I'm a bit old fashioned 🙂
Regards, Iain

Thanks for reply.

Can you please tell me how can i read it by script.