General information
Forum:
Microsoft SQL Server
When given some Excel sheets used as a database I often pipe the excel into a vfp table (either all fields memo or created via import wizard) and create a small program fixing all peculiarities from that first stage table in a second, fixed stage table. The second table then is either directly accessed or bulk-loaded via CSV. Data amounts typically starting with a few thousand rows if Excel was manually filled (often zero prefixed "numbers" being problematic) or to more than a few 10K batches if filled from a CD or from web (often column alignment/filling problems) - esp. bad if filled in many steps. Row flagging and browsing easy to do in vfp ;-)) Benefit mostly that errors found later can easily be added into the smal program and task run again, creating new corrected 2. stage table
>I'm importing to sql from some spreadsheets.
>I'm saving the data as tab delimited as going straight from the excel sheet was causing many issues.
>
>My problem is that some data cells contain a lot of text. This displays ok in excel with formatting new lines etc. But when I save as tab delimited all that formatting is lost and I wanted to save each line a s a separate note.
>
>Any ideas on how I can save that formatting or split up the text. (here's an example with formatting )
>
>26/02/16 JP RE said get surveyor or Steve to inspect and report back.
>25/02/16 JP Emailed KM to ask if the fencers have put in their report
>25/02/16 JP Kerrie emailed: cannot re-band if council say no. Her best chance is MX and there's a 2 bed ground floor flat in xxxx she could go for. Kerrie suggested speaking to Jemma or Sally as they'll know her band and where's she's coming on the bidding list.
>
>
>Any way I can split on the date string pattern ?
>
>
>Thanks
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only