Information générale
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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement