September 26, 2005 at 7:05 am
I have a file that looks like this:
Amber Wood Photgraphy
252 Ashley Road
Parkstone
Poole
Dorset
Poole
Dorset
BH14 9BZ
GB
United Kingdom
=====================
Oakbridge Estates Ltd
Trading As: Oakbridge Estates Ltd
Attn Robert Cook
Unit 3a Treloggan Ind Estate
Newquay
Cornwall
TR7 2SX United Kingdom
And I want it to look like the slightly more conventional
Amber Wood Photography,252 Ashley Road,Parkstone... etc etc
Oakbridge Estates LTD, Trading as ... etc etc
Does anybody know of any ways I can do this?
Thanks
Mark
September 26, 2005 at 7:24 am
What do you want to do with that file afterwards?
September 26, 2005 at 7:31 am
I beasically just want to take the text file move it into a SQL database for storage(Once I've got it in there will be updates to run etc, it's just getting it into SQL in its current state) and then provide a much nicer neater .csv file to a colleague for his usage.
September 26, 2005 at 7:39 am
You can define a linked sever to the text file. Read the content into a temp table and pivot the rows into columns into another temp table, then insert it into another text file.
check "linked servers, access an Access database" in the index of BOL.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply